| 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 | ||