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 |