| Adding Mon Apr 24 2017 08:47:31 GMT+0100 (BST) | |||||
| Number failed: 1Number passed:59File: /Servers/htdocs/test/2013/js/day/tests/scripts//Adding.testScript | |||||
| Line | Test | Expected | Actual | Comment | |
| # ADDING TESTS | |||||
| # ------------ | |||||
| # 2009 is a normal year | |||||
| 5 | ADDDAYS(20 Feb 2009,0) | 20 Feb 2009 | |||
| 6 | ADDDAYS(20 Feb 2009,1) | 21 Feb 2009 | |||
| 7 | ADDDAYS(20 Feb 2009,2) | 22 Feb 2009 | |||
| 8 | ADDDAYS(20 Feb 2009,3) | 23 Feb 2009 | |||
| 9 | ADDDAYS(20 Feb 2009,4) | 24 Feb 2009 | |||
| 10 | ADDDAYS(20 Feb 2009,5) | 25 Feb 2009 | |||
| 11 | ADDDAYS(20 Feb 2009,6) | 26 Feb 2009 | |||
| 12 | ADDDAYS(20 Feb 2009,7) | 27 Feb 2009 | |||
| 13 | ADDDAYS(20 Feb 2009,8) | 28 Feb 2009 | |||
| 14 | ADDDAYS(20 Feb 2009,9) | 1 Mar 2009 | |||
| 15 | ADDDAYS(20 Feb 2009,10) | 2 Mar 2009 | |||
| 16 | ADDDAYS(20 Feb 2009,11) | 3 Mar 2009 | |||
| 17 | ADDDAYS(20 Feb 2009,12) | 4 Mar 2009 | |||
| 18 | ADDDAYS(20 Feb 2009,22) | 14 Mar 2009 | |||
| 19 | ADDDAYS(20 Feb 2009,32) | 24 Mar 2009 | |||
| 20 | ADDDAYS(20 Feb 2009,39) | 31 Mar 2009 | |||
| 21 | ADDDAYS(20 Feb 2009,40) | 1 Apr 2009 | |||
| 22 | ADDDAYS(20 Feb 2009,70) | 1 May 2009 | |||
| 23 | ADDDAYS(20 Feb 2009,365) | 20 Feb 2010 | |||
| # 2008 is a leap year | |||||
| 25 | ADDDAYS(20 Feb 2008,7) | 27 Feb 2008 | |||
| 26 | ADDDAYS(20 Feb 2008,8) | 28 Feb 2008 | |||
| 27 | ADDDAYS(20 Feb 2008,9) | 29 Feb 2008 | |||
| 28 | ADDDAYS(20 Feb 2008,10) | 1 Mar 2008 | |||
| 29 | ADDDAYS(20 Feb 2008,11) | 2 Mar 2008 | |||
| # Subtraction | |||||
| 32 | ADDDAYS(20 Feb 2009,-1) | 19 Feb 2009 | |||
| 33 | ADDDAYS(20 Feb 2010,-365) | 20 Feb 2009 | |||
| 34 | ADDDAYS(20 Feb 2010,-731) | 20 Feb 2008 | |||
| # Crossing BC-AD boundary | |||||
| 37 | ADDDAYS(3 August 0077 BC,0) | 3 Aug 0077 BC | |||
| 38 | ADDDAYS(30 Dec 0001 BC,1) | 31 Dec 0001 BC | |||
| 39 | ADDDAYS(30 Dec 0001 BC,2) | 1 Jan 0001 | |||
| 40 | ADDDAYS(01 Jan 0001,-1) | 31 Dec 0001 BC | |||
| 42 | ADDMONTHS(1 jan 2008,1) | 1 Feb 2008 | |||
| 43 | ADDMONTHS(1 JAN 2008,2) | 1 Mar 2008 | |||
| 44 | ADDMONTHS(1 JAN 2009,2) | 1 Mar 2009 | |||
| 45 | ADDMONTHS(1 JAN 2009,24) | 1 Jan 2011 | |||
| 46 | ADDMONTHS(1 JAN 2011,-24) | 1 Jan 2009 | |||
| 47 | ADDMONTHS(1 JAN 2008,24) | 1 Jan 2010 | |||
| 48 | ADDMONTHS(1 JAN 2010,-24) | 1 Jan 2008 | |||
| 49 | ADDMONTHS(31 JAN 2008,1) | 29 Feb 2008 | |||
| 50 | ADDMONTHS(31 JAN 2008,2) | 31 Mar 2008 | |||
| 51 | ADDMONTHS(31 JAN 2009,2) | 31 Mar 2009 | |||
| 52 | ADDMONTHS(31 JAN 2008,24) | 31 Jan 2010 | |||
| 53 | ADDMONTHS(31 JAN 2010,-24) | 31 Jan 2008 | |||
| 54 | ADDMONTHS(31 JAN 2009,1) | 28 Feb 2009 | |||
| 55 | ADDMONTHS(30 JAN 2009,1) | 27 Feb 2009 | |||
| 56 | ADDMONTHS(29 JAN 2009,1) | 26 Feb 2009 | |||
| # partial | |||||
| 60 | ADDMONTHS(5 Mar,3) | 5 Jun | 5 Jun 2017 | ||
| 61 | ADDMONTHS(Mar 2008,3) | Jun 2008 | |||
| 62 | ADDMONTHS(2008,3) | EXCEPTION: Can't add month to bare year in DAYo.AddMonths() ??? | |||
| # Across AD/BC | |||||
| 65 | ADDMONTHS(15 Dec 0001 BC,12) | 15 Dec 0001 | |||
| 66 | ADDMONTHS(15 Dec 0001,-12) | 15 Dec 0001 BC | |||
| 69 | ADDYEARS(1 jan 2008,1) | 1 Jan 2009 | |||
| 70 | ADDYEARS(28 feb 2008,1) | 27 Feb 2009 | |||
| 71 | ADDYEARS(29 feb 2008,1) | 28 Feb 2009 | |||
| 72 | ADDYEARS(28 feb 2009,-1) | 29 Feb 2008 | |||
| 73 | ADDYEARS(Sept 1984,10) | Sep 1994 | |||
| 74 | ADDYEARS(1984,10) | 1994 | |||
| 75 | ADDYEARS(1984,-10) | 1974 | |||
| 76 | ADDYEARS(0004,-4) | 0001 BC | |||
| 77 | ADDYEARS(0004,-10) | 0007 BC | |||