InputDate Mon Apr 24 2017 08:47:31 GMT+0100 (BST)
Number failed: 67Number passed:146File: /Servers/htdocs/test/2013/js/day/tests/scripts//InputDate.testScript
LineTestExpectedActualComment
# CONVERTING STRINGS TO DATES
# -----------------------------------------
# Format: Function (Input) Expected_result [#comment]
# Conversions to dates See also: ImpliedYear and InputInterval
6SETCONFIG(DM_ORDER,DMY)DM_ORDER set to DMY British D-M order
# Special values
10DATEFROMSTRING()Not valid(1)
11DATEFROMSTRING(EoT)End-of-Time
12DATEFROMSTRING(End-of-Time)End-of-Time
13DATEFROMSTRING(E)End-of-Time
14DATEFROMSTRING(BoT)Beg-of-Time
15DATEFROMSTRING(Beg-of-Time)Beg-of-Time
16DATEFROMSTRING(B)Beg-of-Time
17DATEFROMSTRING(U)Unknown
18DATEFROMSTRING(Unknown)Unknown
19DATEFROMSTRING(NOT VALID)Not valid(0) Unknown/OK
20DATEFROMSTRING(!)Not valid(0) Unknown short form
# 6 and 8 digits all together
# ---------------------------
24DATEFROMSTRING(010203)1 Feb 2003
25DATEFROMSTRING(011203)1 Dec 2003
26DATEFROMSTRING(01122003)1 Dec 2003
27DATEFROMSTRING(01122013)1 Dec 2013
28DATEFROMSTRING(01122113)1 Dec 2113
29DATEFROMSTRING(01121913)1 Dec 1913
30DATEFROMSTRING(01121813)1 Dec 1813
# forcing day-of-month that are too large to max length of month
32SETCONFIG(ALLOW_31_TO_30, 1)ALLOW_31_TO_30 set to 1following should all pass
33DATEFROMSTRING(31112009)30 Nov 2009
34DATEFROMSTRING(32112009)Not valid(2) [_SetCalHelper via FromText]
Bad day or month 32/11/2009
35DATEFROMSTRING(31022008)29 Feb 2008 leap year
# Hovering around year 0 etc
37DATEFROMSTRING(010100)1 Jan 2000
38DATEFROMSTRING(01010000)Not valid(2) [_SetCalHelper via FromText]
Bad year 0/0/0000
39DATEFROMSTRING(010101)1 Jan 2001
40DATEFROMSTRING(01010001)1 Jan 0001
41DATEFROMSTRING(000000)Not valid(2) 00 is a bad year [FromText]
Zero token is not valid
42DATEFROMSTRING(00000000)Not valid(2) 0000 is a bad year [FromText]
Zero token is not valid
43DATEFROMSTRING(00032004)Mar 2004
44DATEFROMSTRING(65122004)Not valid(2) [_SetCalHelper via FromText]
Bad day or month 65/12/2004
45DATEFROMSTRING(03132004)Not valid(2) [_SetCalHelper via FromText]
Bad day or month 3/13/2004
46DATEFROMSTRING(03047004)Not valid(2) [_SetCalHelper via FromText]
Bad day or month 3/4/7004
# Three separate tokens
51DATEFROMSTRING(1 1 2000)1 Jan 2000
52DATEFROMSTRING(2 1 2000)2 Jan 2000
53DATEFROMSTRING(3 1 2000)3 Jan 2000
54DATEFROMSTRING(9 4 2000)9 Apr 2000
55DATEFROMSTRING(9 Apr 2000)9 Apr 2000
56DATEFROMSTRING(9 Ap 2000)9 Apr 2000
57DATEFROMSTRING(9 A 2000)Not valid(2) [FromText]Unknown month
name
58DATEFROMSTRING(31 Jan 07)31 Jan 2007
59DATEFROMSTRING(31 Feb 07)28 Feb 2007
60DATEFROMSTRING(Aug 12 2001)12 Aug 2001Can o/w day first if needed
61DATEFROMSTRING(12 Aug 2001)12 Aug 2001
63DATEFROMSTRING(31 Feb 08)29 Feb 2008 leap year
64DATEFROMSTRING(31 Mar 00)31 Mar 2000Not valid(2) [FromText] Zero token is not
valid
65DATEFROMSTRING(31 Apr 00)30 Apr 2000Not valid(2) [FromText] Zero token is not
valid
66DATEFROMSTRING(31 May 00)31 May 2000Not valid(2) [FromText] Zero token is not
valid
67DATEFROMSTRING(31 Jun 00)30 Jun 2000Not valid(2) [FromText] Zero token is not
valid
68DATEFROMSTRING(31 Jul 00)31 Jly 2000Not valid(2) allow Jul as input but use Jly as outputclass=tags> [FromText] Zero token is not
valid
69DATEFROMSTRING(31 Jly 00)31 Jly 2000Not valid(2) [FromText] Zero token is not
valid
70DATEFROMSTRING(31 Aug 00)31 Aug 2000Not valid(2) [FromText] Zero token is not
valid
71DATEFROMSTRING(31 Sep 00)30 Sep 2000Not valid(2) [FromText] Zero token is not
valid
72DATEFROMSTRING(31 Oct 00)31 Oct 2000Not valid(2) [FromText] Zero token is not
valid
73DATEFROMSTRING(31 Nov 00)30 Nov 2000Not valid(2) [FromText] Zero token is not
valid
74DATEFROMSTRING(31 Dec 00)31 Dec 2000Not valid(2) [FromText] Zero token is not
valid
75DATEFROMSTRING(31 Jan Dec 00)Not valid(1) [FromText] Multiple
alphas
77DATEFROMSTRING(31 Ja 07)31 Jan 2007
78DATEFROMSTRING(31 F 07)28 Feb 2007
79DATEFROMSTRING(31 Mr 00)31 Mar 2000Not valid(2) [FromText] Zero token is not
valid
80DATEFROMSTRING(31 Ap 00)30 Apr 2000Not valid(2) [FromText] Zero token is not
valid
81DATEFROMSTRING(31 My 00)31 May 2000Not valid(2) [FromText] Zero token is not
valid
82DATEFROMSTRING(31 Jun 00)30 Jun 2000Not valid(2) [FromText] Zero token is not
valid
83DATEFROMSTRING(31 Jul 00)31 Jly 2000Not valid(2) [FromText] Zero token is not
valid
84DATEFROMSTRING(31 Au 00)31 Aug 2000Not valid(2) [FromText] Zero token is not
valid
85DATEFROMSTRING(31 Se 00)30 Sep 2000Not valid(2) [FromText] Zero token is not
valid
86DATEFROMSTRING(31 O 00)31 Oct 2000Not valid(2) [FromText] Zero token is not
valid
87DATEFROMSTRING(30 No 00)30 Nov 2000Not valid(2) [FromText] Zero token is not
valid
88DATEFROMSTRING(31 N 00)Not valid(2) [FromText]Unknown month
name
89DATEFROMSTRING(31 D 00)31 Dec 2000Not valid(2) [FromText] Zero token is not
valid
# allowing overflow dates to be coerced to last day of month (ALLOW_31_TO_30) already set
92EXPLAIN() DM_ORDER=DMY IMPLIED_YEAR=-1 BC_INDICATOR=BC
TWO_DIGIT_FIX=50 ALLOW_31_TO_30=1 ALLOW_DAY_ONLY_INT=1
error= appendix=en-gb.dax
force2or4DigitYears=false Default year=2017
93DATEFROMSTRING(30 Nov 2010)30 Nov 2010Always passes
94DATEFROMSTRING(31 Nov 2010)30 Nov 2010Only passes if ALLOW_31_TO_30 = 1
95DATEFROMSTRING(32 Nov 2010)Not valid(2) [_SetCalHelper via FromText]
Bad day or month 32/11/2010
96DATEFROMSTRING(29 Feb 2010)28 Feb 2010Only passes if ALLOW_31_TO_30 = 1
97DATEFROMSTRING(29 Feb 2008)29 Feb 2008Always passes
99SETCONFIG(ALLOW_31_TO_30, 0)ALLOW_31_TO_30 set to 0 dis-allow day coercing
100EXPLAIN() DM_ORDER=DMY IMPLIED_YEAR=-1 BC_INDICATOR=BC
TWO_DIGIT_FIX=50 ALLOW_31_TO_30=0 ALLOW_DAY_ONLY_INT=1
error= appendix=en-gb.dax
force2or4DigitYears=false Default year=2017
101DATEFROMSTRING(31 Nov 2010)Not valid(2) [_SetCalHelper via FromText]
Day beyond end of month
102DATEFROMSTRING(29 Feb 2010)Not valid(2) [_SetCalHelper via FromText]
Day beyond end of month
103DATEFROMSTRING(31 Ap 00)Not valid(2) [FromText] Zero token is not
valid
# Strangely formatted input
106DATEFROMSTRING(NULL)Not valid(2) [FromText]Unknown month
name
107DATEFROMSTRING(Z)Not valid(2) [FromText]Unknown month
name
108DATEFROMSTRING(ZZ)Not valid(2) [FromText]Unknown month
name
109DATEFROMSTRING(ZZZ)Not valid(2) [FromText]Unknown month
name
110DATEFROMSTRING(ZZZZ)Not valid(2) [FromText]Unknown month
name
111DATEFROMSTRING(ZZZZZ)Not valid(2) [FromText]Unknown month
name
112DATEFROMSTRING(ZZZZZZ)Not valid(2) [FromText]Unknown month
name
113DATEFROMSTRING(ZZZZZZZ)Not valid(2) [FromText]Unknown month
name
114DATEFROMSTRING(ZZZZZZZZ)Not valid(2) [FromText]Unknown month
name
115DATEFROMSTRING(ZZZZZZZZZ)Not valid(2) [FromText]Unknown month
name
116DATEFROMSTRING(ZZZZZZZZZZ)Not valid(2) [FromText]Unknown month
name
117DATEFROMSTRING(ZZZZZZZZZZZ)Not valid(2) [FromText]Unknown month
name
118DATEFROMSTRING(ZZZZZZZZZZZZ)Not valid(2) [FromText]Unknown month
name
119DATEFROMSTRING(ZZZZZZZZZZZZZ)Not valid(2) [FromText]Unknown month
name
120DATEFROMSTRING(ZZZZZZZZZZZZZZ)Not valid(2) [FromText]Unknown month
name
121DATEFROMSTRING(ZZZZZZZZZZZZZZZ)Not valid(2) [FromText]Unknown month
name
#DATEFROMSTRING (ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ) NOT VALID(2)
123DATEFROMSTRING(@@@)Not valid(2) Illegal characters get lost so this is almost
equiv. to () [FromText]Unknown
month name
124DATEFROMSTRING(1 11 12)1 Nov 2012
125DATEFROMSTRING(1/11/12)1 Nov 2012
126DATEFROMSTRING(1\11\12)1 Nov 2012
127DATEFROMSTRING(1.11.12)1 Nov 2012
128DATEFROMSTRING(1.11/12)1 Nov 2012
129DATEFROMSTRING(1.11.12)1 Nov 2012
130DATEFROMSTRING(1'11'12)1 Nov 2012
131DATEFROMSTRING(1COMMA11COMMA12)Not valid(2) [A-Z] are 'valid' characters during parseclass=tags> [FromText] Unexpected alpha
132DATEFROMSTRING(1_11_12)1 Nov 2012
133DATEFROMSTRING(1%%%%11&&&12)1 Nov 2012
134DATEFROMSTRING(99.99.99)Not valid(2) [FromText] Out of range M and
D
#SETCONFIG (ALLOW_31_TO_30, 1) # allow day coercing
138EXPLAIN() DM_ORDER=DMY IMPLIED_YEAR=-1 BC_INDICATOR=BC
TWO_DIGIT_FIX=50 ALLOW_31_TO_30=0 ALLOW_DAY_ONLY_INT=1
error= appendix=en-gb.dax
force2or4DigitYears=false Default year=2017
### Partial year conversion ###
### Two_digit_fix has three possible values ###
143SETCONFIG(TWO_DIGIT_FIX,0)TWO_DIGIT_FIX set to 0
144DATEFROMSTRING(010199)NOT VALID(2)EXCEPTION:
TypeError: Object # has no method '_SetNvhelper'
Line: Object # has no method '_SetNvhelper' File: TypeError
145DATEFROMSTRING(010150)NOT VALID(2)EXCEPTION:
TypeError: Object # has no method '_SetNvhelper'
Line: Object # has no method '_SetNvhelper' File: TypeError
146SETCONFIG(TWO_DIGIT_FIX,20)TWO_DIGIT_FIX set to 20
147DATEFROMSTRING(010199)1 Jan 2099
148DATEFROMSTRING(010150)1 Jan 2050 20=ok 50=ok 0=fail
149SETCONFIG(TWO_DIGIT_FIX,50)TWO_DIGIT_FIX set to 50
150DATEFROMSTRING(010199)1 Jan 1999 20=fail 50=ok 0=fail
151DATEFROMSTRING(010150)1 Jan 2050 20=ok 50=ok 0=fail
#### Partial dates ####
155DATEFROMSTRING(Jan 2007)Jan 2007
156DATEFROMSTRING(2007)2007
157DATEFROMSTRING(07)2007
158DATEFROMSTRING(00)2000Not valid(2) [FromText] Zero token is not
valid
160DATEFROMSTRING(JAN)Jan
161DATEFROMSTRING(jAN)Jan
162DATEFROMSTRING(jAnUaRy)Jan
163DATEFROMSTRING(Feb)Feb
164DATEFROMSTRING(F)Feb
165DATEFROMSTRING(Mar)Mar
166DATEFROMSTRING(Apr)Apr
167DATEFROMSTRING(May)May
168DATEFROMSTRING(Jun)Jun
169DATEFROMSTRING(Jul)Jly
170DATEFROMSTRING(July)Jly
171DATEFROMSTRING(Aug)Aug
172DATEFROMSTRING(Auguxxxx)Aug
173DATEFROMSTRING(Auguxxxx 2008)Aug 2008
174DATEFROMSTRING(Sep)Sep
175DATEFROMSTRING(Oct)Oct
176DATEFROMSTRING(Nov)Nov
177DATEFROMSTRING(Dec)Dec
# BC
183DATEFROMSTRING(34 BC)0034 BC
184DATEFROMSTRING(0015 BC)0015 BC
185DATEFROMSTRING(Nov 0004 BC)Nov 0004 BC4 Nov BC
186DATEFROMSTRING(31 Dec 0001 BC)31 Dec 0001 BC
187DATEFROMSTRING(31 Dec 01 BC)31 Dec 0001 BC31 Dec 2001 BC
188DATEFROMSTRING(31 Dec 1 BC)31 Dec 0001 BC31 Dec 2001 BC
189DATEFROMSTRING(30 Dec 0001 BC)30 Dec 0001 BC
190DATEFROMSTRING(5 Mar 2006 BC)5 Mar 2006 BC
191DATEFROMSTRING(30 Dec 0001 bc)30 Dec 0001 BC
# Two tokens
195SETCONFIG(DM_ORDER,DMY)DM_ORDER set to DMY British D-M order
196SETCONFIG(TWO_DIGIT_FIX,20)TWO_DIGIT_FIX set to 20
197SETCONFIG(ALLOW_31_TO_30, 0)ALLOW_31_TO_30 set to 0
198SETCONFIG(IMPLIED_YEAR, 0)IMPLIED_YEAR set to 0 no missing years allowed ... should all fail
199EXPLAIN() DM_ORDER=DMY IMPLIED_YEAR=0 BC_INDICATOR=BC
TWO_DIGIT_FIX=20 ALLOW_31_TO_30=0 ALLOW_DAY_ONLY_INT=1
error= appendix=en-gb.dax
force2or4DigitYears=false Default year=-9999999
200DATEFROMSTRING(7 Mar)Not valid(2) [FromText] Year is required.
ImpliedYear=0
201DATEFROMSTRING(22 Mar)Not valid(2) [FromText] Year is required.
ImpliedYear=0
202DATEFROMSTRING(Mar 7)Not valid(2) [FromText] Year is required.
ImpliedYear=0
203DATEFROMSTRING(Mar 22)Not valid(2) [FromText] Year is required.
ImpliedYear=0
204DATEFROMSTRING(Feb 28)Not valid(2) [FromText] Year is required.
ImpliedYear=0
205DATEFROMSTRING(Feb 29)Not valid(2)Feb 2029
206DATEFROMSTRING(Feb 30)Not valid(2)Feb 2030
207DATEFROMSTRING(Feb 31)Not valid(2)Feb 2031
208DATEFROMSTRING(Feb 32)Not valid(2)Feb 2032
# Two tokens - substitute current year
211SETCONFIG(TWO_DIGIT_FIX,0)TWO_DIGIT_FIX set to 0
212SETCONFIG(ALLOW_31_TO_30, 0)ALLOW_31_TO_30 set to 0
213SETCONFIG(IMPLIED_YEAR, -1)IMPLIED_YEAR set to -1
214EXPLAIN() DM_ORDER=DMY IMPLIED_YEAR=-1 BC_INDICATOR=BC
TWO_DIGIT_FIX=0 ALLOW_31_TO_30=0 ALLOW_DAY_ONLY_INT=1
error= appendix=en-gb.dax
force2or4DigitYears=false Default year=2017
215DATEFROMSTRING(2 Mar)?2 Mar 2017
216DATEFROMSTRING(22 Mar)?22 Mar 2017
217DATEFROMSTRING(Mar 2)?2 Mar 2017
218DATEFROMSTRING(Mar 22)?22 Mar 2017
219DATEFROMSTRING(Feb 28)?28 Feb 2017
220DATEFROMSTRING(Feb 29)?Not valid(2) [FromText] Year is required.
ImpliedYear=-1
221DATEFROMSTRING(Feb 30)?Not valid(2) [FromText] Year is required.
ImpliedYear=-1
222DATEFROMSTRING(Feb 31)?Not valid(2) [FromText] Year is required.
ImpliedYear=-1
223DATEFROMSTRING(Feb 32)?Not valid(2) [FromText] Year is required.
ImpliedYear=-1
# Two tokens - allow floats but not 2-digit fix
226SETCONFIG(TWO_DIGIT_FIX,0)TWO_DIGIT_FIX set to 0
227SETCONFIG(ALLOW_31_TO_30, 0)ALLOW_31_TO_30 set to 0
228SETCONFIG(IMPLIED_YEAR, -2)IMPLIED_YEAR set to -2
229DATEFROMSTRING(2 Mar)?2 Mar
230DATEFROMSTRING(22 Mar)?22 Mar
231DATEFROMSTRING(Mar 2)?2 Mar
232DATEFROMSTRING(Mar 22)?22 Mar
233DATEFROMSTRING(Feb 28)?28 Feb
234DATEFROMSTRING(Feb 29)?Not valid(2) [FromText] Year is required.
ImpliedYear=-2
235DATEFROMSTRING(Feb 30)?Not valid(2) [FromText] Year is required.
ImpliedYear=-2
236DATEFROMSTRING(Feb 31)?Not valid(2) [FromText] Year is required.
ImpliedYear=-2
237DATEFROMSTRING(Feb 32)?Not valid(2) [FromText] Year is required.
ImpliedYear=-2
# Two tokens - allow floats and 2-digit fix
240SETCONFIG(TWO_DIGIT_FIX,0)TWO_DIGIT_FIX set to 0
241SETCONFIG(ALLOW_31_TO_30, 0)ALLOW_31_TO_30 set to 0
242SETCONFIG(IMPLIED_YEAR, -2)IMPLIED_YEAR set to -2
243DATEFROMSTRING(2 Mar)?2 Mar
244DATEFROMSTRING(22 Mar)?22 Mar
245DATEFROMSTRING(Mar 2)?2 Mar
246DATEFROMSTRING(Mar 22)?22 Mar
247DATEFROMSTRING(Feb 28)?28 Feb
248DATEFROMSTRING(Feb 29)?Not valid(2) [FromText] Year is required.
ImpliedYear=-2
249DATEFROMSTRING(Feb 30)?Not valid(2) [FromText] Year is required.
ImpliedYear=-2
250DATEFROMSTRING(Feb 31)?Not valid(2) [FromText] Year is required.
ImpliedYear=-2
251DATEFROMSTRING(Feb 32)?Not valid(2) [FromText] Year is required.
ImpliedYear=-2
# Two tokens - substitute specific year
254SETCONFIG(TWO_DIGIT_FIX,0)TWO_DIGIT_FIX set to 0
255SETCONFIG(ALLOW_31_TO_30, 0)ALLOW_31_TO_30 set to 0
256SETCONFIG(IMPLIED_YEAR, 2012)IMPLIED_YEAR set to 2012
257DATEFROMSTRING(2 Mar)?2 Mar 2012
258DATEFROMSTRING(22 Mar)?22 Mar 2012
259DATEFROMSTRING(Mar 2)?2 Mar 2012
260DATEFROMSTRING(Mar 22)?22 Mar 2012
261DATEFROMSTRING(Feb 28)?28 Feb 2012
262DATEFROMSTRING(Feb 29)?Not valid(2) [FromText] Year is required.
ImpliedYear=2012
263DATEFROMSTRING(Feb 30)?Not valid(2) [FromText] Year is required.
ImpliedYear=2012
264DATEFROMSTRING(Feb 31)?Not valid(2) [FromText] Year is required.
ImpliedYear=2012
265DATEFROMSTRING(Feb 32)?Not valid(2) [FromText] Year is required.
ImpliedYear=2012