EarliestLatest Mon Apr 24 2017 08:47:31 GMT+0100 (BST) | |||||
Number failed: 41Number passed:56File: /Servers/htdocs/test/2013/js/day/tests/scripts//EarliestLatest.testScript | |||||
Line | Test | Expected | Actual | Comment | |
# Earliest, latest | |||||
# ---------------- | |||||
# ------- exact dates | |||||
5 | EARLIESTSTART(16 Feb 2009,16 Feb 2009) | 16 Feb 2009 | |||
6 | LATESTSTART(16 Feb 2009,16 Feb 2009) | 16 Feb 2009 | |||
7 | LATESTFINISH(16 Feb 2009,16 Feb 2009) | 16 Feb 2009 | |||
8 | EARLIESTFINISH(16 Feb 2009,16 Feb 2009) | 16 Feb 2009 | |||
10 | EARLIESTSTART(1 Feb 2009,11 Feb 2009) | 1 Feb 2009 | |||
11 | LATESTSTART(1 Feb 2009,11 Feb 2009) | 11 Feb 2009 | |||
12 | LATESTFINISH(1 Feb 2009,11 Feb 2009) | 11 Feb 2009 | |||
13 | EARLIESTFINISH(1 Feb 2009,11 Feb 2009) | 1 Feb 2009 | |||
15 | EARLIESTSTART(1 Feb 2001,2 Feb 2002,3 Feb 2003,4 Feb 2004) | 1 Feb 2001 | |||
16 | LATESTSTART(1 Feb 2001,2 Feb 2002,3 Feb 2003,4 Feb 2004) | 4 Feb 2004 | |||
17 | LATESTFINISH(1 Feb 2001,2 Feb 2002,3 Feb 2003,4 Feb 2004) | 4 Feb 2004 | |||
18 | EARLIESTFINISH(1 Feb 2001,2 Feb 2002,3 Feb 2003,4 Feb 2004) | 1 Feb 2001 | |||
# -------- periods | |||||
23 | EARLIESTSTART(16 Feb 2009,Feb 2009) | 1 Feb 2009 | |||
24 | EARLIESTSTART(16 Feb 2009,2009) | 1 Jan 2009 | |||
25 | EARLIESTSTART(Feb 2009,2009) | 1 Jan 2009 | |||
26 | EARLIESTSTART(Feb 2009,Feb 2009) | 1 Feb 2009 | |||
27 | EARLIESTSTART(May 2009,Feb 2009) | 1 Feb 2009 | |||
28 | EARLIESTSTART(2009,2011) | 1 Jan 2009 | |||
30 | LATESTSTART(16 Feb 2009,Feb 2009) | 16 Feb 2009 | |||
31 | LATESTSTART(16 Feb 2009,2009) | 16 Feb 2009 | |||
32 | LATESTSTART(Feb 2009,2009) | 1 Feb 2009 | |||
33 | LATESTSTART(Feb 2009,Feb 2009) | 1 Feb 2009 | |||
34 | LATESTSTART(May 2009,Feb 2009) | 1 May 2009 | |||
35 | LATESTSTART(2009,2011) | 1 Jan 2011 | |||
37 | EARLIESTFINISH(16 Feb 2009,Feb 2009) | 16 Feb 2009 | |||
38 | EARLIESTFINISH(16 Feb 2009,2009) | 16 Feb 2009 | |||
39 | EARLIESTFINISH(Feb 2009,2009) | 28 Feb 2009 | |||
40 | EARLIESTFINISH(Feb 2009,Feb 2009) | 28 Feb 2009 | |||
41 | EARLIESTFINISH(May 2009,Feb 2009) | 28 Feb 2009 | |||
42 | EARLIESTFINISH(2009,2011) | 31 Dec 2009 | |||
44 | LATESTFINISH(16 Feb 2009,Feb 2009) | 28 Feb 2009 | |||
45 | LATESTFINISH(16 Feb 2009,2009) | 31 Dec 2009 | |||
46 | LATESTFINISH(Feb 2009,2009) | 31 Dec 2009 | |||
47 | LATESTFINISH(Feb 2009,Feb 2009) | 28 Feb 2009 | |||
48 | LATESTFINISH(May 2009,Feb 2009) | 31 May 2009 | |||
49 | LATESTFINISH(2009,2011) | 31 Dec 2011 | |||
# ---- unsuitable values (Same validation except for BoT/EoT used for all) | |||||
54 | EARLIESTSTART(16 Feb 2009,Feb 2009,U) | 1 Feb 2009 | Beg-of-Time | ||
55 | EARLIESTSTART(16 Feb 2009,Feb 2009,X) | 1 Feb 2009 | EXCEPTION: [FromText] doesn't take intervals ??? | ||
56 | EARLIESTSTART(16 Feb 2009,Feb 2009,!) | 1 Feb 2009 | EXCEPTION: Unsuitable date for EarliestStart() ??? | ||
57 | EARLIESTSTART(16 Feb 2009,Feb 2009,B) | 1 Feb 2009 | Beg-of-Time | ||
58 | EARLIESTSTART(16 Feb 2009,Feb 2009,E) | 1 Feb 2009 | |||
59 | EARLIESTSTART(16 Feb 2009,Feb 2009,18 May) | 1 Feb 2009 | float! | ||
65 | EARLIESTSTART(Feb 2009,16 Feb 2009) | 1 Feb 2009 | |||
66 | LATESTSTART(Feb 2009,16 Feb 2009) | 16 Feb 2009 | |||
67 | EARLIESTSTART(10 Feb 2009,16 Feb 2009) | 10 Feb 2009 | |||
68 | LATESTSTART(10 Feb 2009,16 Feb 2009) | NOT VALID No concurrency | 16 Feb 2009 | ||
69 | EARLIESTSTART(Feb 2009,Feb 2009) | 1 Feb 2009 | |||
70 | LATESTSTART(2009,2009) | 1 Jan 2009 | |||
71 | EARLIESTSTART(2009,16 Feb 2009) | 1 Jan 2009 | |||
72 | LATESTSTART(2009,16 Feb 2009) | 16 Feb 2009 | |||
73 | EARLIESTSTART(BoT,16 Feb 2009) | NOT VALID Function failure | Beg-of-Time | ||
74 | LATESTSTART(BoT,16 Feb 2009) | NOT VALID Function failure | Beg-of-Time | ||
75 | EARLIESTSTART(16 Feb 2009,EoT) | NOT VALID Function failure | 16 Feb 2009 | ||
76 | LATESTSTART(16 Feb 2009,EoT) | NOT VALID Function failure | End-of-Time | ||
77 | EARLIESTSTART(16 Feb 2009,X) | NOT VALID Function failure | EXCEPTION: [FromText] doesn't take intervals ??? | ||
78 | LATESTSTART(16 Feb 2009,X) | NOT VALID Function failure | EXCEPTION: [FromText] doesn't take intervals ??? | ||
79 | EARLIESTSTART(16 Feb 2009,U) | NOT VALID Function failure | Beg-of-Time | ||
80 | LATESTSTART(16 Feb 2009,U) | NOT VALID Function failure | 16 Feb 2009 | ||
81 | EARLIESTSTART(BoT,EoT) | NOT VALID Function failure | Beg-of-Time | ||
82 | LATESTSTART(BoT,EoT) | NOT VALID Function failure | End-of-Time | ||
83 | EARLIESTSTART(U,EoT) | End-of-Time | Beg-of-Time | ||
84 | LATESTSTART(U,EoT) | NOT VALID Function failure | End-of-Time | ||
85 | EARLIESTSTART(U,BoT) | NOT VALID Function failure | Beg-of-Time | ||
86 | LATESTSTART(U,BoT) | NOT VALID Function failure | Beg-of-Time | ||
87 | EARLIESTSTART(U,X) | NOT VALID Function failure | EXCEPTION: [FromText] doesn't take intervals ??? | ||
88 | EARLIESTSTART(U,X) | NOT VALID Function failure | EXCEPTION: [FromText] doesn't take intervals ??? | ||
89 | EARLIESTSTART(U,U) | NOT VALID Function failure | Beg-of-Time | ||
90 | EARLIESTSTART(U,U) | NOT VALID Function failure | Beg-of-Time | ||
94 | LATESTFINISH(16 Feb 2009,16 Feb 2009) | 16 Feb 2009 | |||
95 | EARLIESTFINISH(16 Feb 2009,16 Feb 2009) | 16 Feb 2009 | |||
96 | LATESTFINISH(Feb 2009,16 Feb 2009) | 28 Feb 2009 | |||
97 | LATESTFINISH(Feb 2008,16 Feb 2008) | 29 Feb 2008 | |||
98 | EARLIESTFINISH(Feb 2009,16 Feb 2009) | 16 Feb 2009 | |||
99 | LATESTFINISH(10 Feb 2009,16 Feb 2009) | 16 Feb 2009 | |||
100 | EARLIESTFINISH(10 Feb 2009,16 Feb 2009) | NOT VALID No concurrency | 10 Feb 2009 | ||
101 | LATESTFINISH(Feb 2009,Feb 2009) | 28 Feb 2009 | |||
102 | EARLIESTFINISH(2009,2009) | 31 Dec 2009 | |||
103 | LATESTFINISH(2009,16 Feb 2009) | 31 dec 2009 | 31 Dec 2009 | ||
104 | EARLIESTFINISH(2009,16 Feb 2009) | 16 Feb 2009 | |||
105 | LATESTFINISH(BoT,16 Feb 2009) | NOT VALID Function failure | Beg-of-Time | ||
106 | EARLIESTFINISH(BoT,16 Feb 2009) | NOT VALID Function failure | Beg-of-Time | ||
107 | LATESTFINISH(16 Feb 2009,EoT) | NOT VALID Function failure | End-of-Time | ||
108 | EARLIESTFINISH(16 Feb 2009,EoT) | NOT VALID Function failure | 16 Feb 2009 | ||
109 | LATESTFINISH(16 Feb 2009,X) | NOT VALID Function failure | EXCEPTION: [FromText] doesn't take intervals ??? | ||
110 | EARLIESTFINISH(16 Feb 2009,X) | NOT VALID Function failure | EXCEPTION: [FromText] doesn't take intervals ??? | ||
111 | LATESTFINISH(16 Feb 2009,U) | NOT VALID Function failure | End-of-Time | ||
112 | EARLIESTFINISH(16 Feb 2009,U) | NOT VALID Function failure | 16 Feb 2009 | ||
113 | LATESTFINISH(BoT,EoT) | NOT VALID Function failure | End-of-Time | ||
114 | EARLIESTFINISH(BoT,EoT) | NOT VALID Function failure | Beg-of-Time | ||
115 | LATESTFINISH(U,EoT) | End-of-Time | |||
116 | EARLIESTFINISH(U,EoT) | NOT VALID Function failure | End-of-Time | ||
117 | LATESTFINISH(U,BoT) | NOT VALID Function failure | End-of-Time | ||
118 | EARLIESTFINISH(U,BoT) | Beg-of-Time | |||
119 | LATESTFINISH(U,X) | NOT VALID Function failure | EXCEPTION: [FromText] doesn't take intervals ??? | ||
120 | LATESTFINISH(U,X) | NOT VALID Function failure | EXCEPTION: [FromText] doesn't take intervals ??? | ||
121 | LATESTFINISH(U,U) | NOT VALID Function failure | End-of-Time | ||
122 | LATESTFINISH(U,U) | NOT VALID Function failure | End-of-Time |