How to Convert a Text Date-time to a Numeric Element
Do you know how to convert a text date-time into a numeric (or full serial datetime) element in TM1? For example, if you have an Excel file as the original source with a date time formatted from a date serial. In Excel the data displayed as, say, “2021-07-06 06:30” and is stored as 44383.2708333333. However, […]
YEAR Function in TM1: Syntax and Use
The YEAR function in TM1 allows us to extract the number representing the Year from a date. Here we explain it’s syntax and give an example combining it with the DATE function.
MONTH Function in TM1: Syntax and Use
The MONTH function in TM1 allows us to extract the number representing the Month from a date. Here we explain it’s syntax and give an example combining it with the DATE function.
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.