Tag Archives: DayNo

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.

DayNo TM1 Function: Use and Syntax

Here we are going to explain how to use the DAYNO TM1 function to convert a date as a string into a serial number. For example, to convert 14-Apr-2016 into the serial number 20558. A bit of background though. Yesterday I was doing some work on an inventory forecasting system.  I had Year, Month and Day dimensions and needed to bring through Actuals for all days up until yesterday. I … Continue Reading