TM1 DATES v/s EXCEL DATES
Dealing with dates in TM1
Both TM1 and Excel use a “date serial” system in which any date that you use in calculations is represented as a positive integer value.
In the case of Excel, the starting date is 31st December 1899. That is, if you enter the value 1 into a cell in Excel and format it as a date, you’ll see the value as 31st December 1899. 2 will be on the 1st of January 1900, 3 the 2nd of January, and so on.In other words, every full day that passes adds 1 to the serial date.