Tag Archives: UseExcelSerialDate

How to Use Excel Dates as Serial Dates in TM1

TM1 and Excel can now share the same serial date system by the use of UseExcelSerialDate=T in your tm1s.cfg file. Here is the details on this development in Planning Analytics. This means that day number 1 is 1-Jan-1900 in both systems.

NOW() TM1 Function: Syntax and Use

The now() function returns a value corresponding with the number of days from either 1 January 1960 or 1 January 1900. It’s the same as the Excel now() function.