Tag Archives: Dates

TM1 and Excel Dates No Longer in Conflict!

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.

This entry was posted in Planning Analytics, TM1 Admin, tm1s.cfg and tagged Dates, Excel, Planning Analytics, UseExcelSerialDate. Bookmark the permalink. | Tagged Dates, Excel, Planning Analytics, UseExcelSerialDate | Leave a comment