DAY TM1 Function: How to Use, Syntax and Example
The TM1 DAY function extracts the Day of Month number from a string based date. For example, DAY (’24-09-18′) will return the number 18.
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.