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, […]
Days in Month – How to Easily Calculate in a TM1 Rule
Here we explain how to calculate the number of days in each month with a simple, but easy rule, using the DAYNO function and a Next Month attribute.
How to Convert a String Date to a Numeric Date in using the DayNo TM1 Function
Syntax and Use of the DayNo function in TM1 Turbo Integrator processes and Rules in TM1. This converts a text date to a serial number.