def test_DATEDIF_year(self):
start_date = date.DATE(2011, 1, 1)
end_date = date.DATE(2011, 12, 31)
self.assertEqual(date.DATEDIF(start_date, end_date, 'Y'), 0)
start_date = date.DATE(2011, 1, 1)
end_date = date.DATE(2012, 12, 31)
self.assertEqual(date.DATEDIF(start_date, end_date, 'Y'), 1)
def test_DATEDIF_M_start_beyond_end(self):
start_date = date.DATE(2002, 8, 15)
end_date = date.DATE(2001, 6, 1)
self.assertIsInstance(date.DATEDIF(start_date, end_date, 'M'),
xlerrors.NumExcelError)
def test_DATEDIF_YD(self):
start_date = date.DATE(2001, 6, 1)
end_date = date.DATE(2002, 8, 15)
self.assertEqual(date.DATEDIF(start_date, end_date, 'YD'), 75)
def test_DATEDIF_YM(self):
start_date = date.DATE(2011, 1, 1)
end_date = date.DATE(2011, 12, 31)
self.assertEqual(date.DATEDIF(start_date, end_date, 'YM'), 11)
def test_DATEDIF_MD(self):
start_date = date.DATE(2011, 1, 1)
end_date = date.DATE(2011, 12, 31)
self.assertEqual(date.DATEDIF(start_date, end_date, 'MD'), 30)