Tag Archives: DayNo
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.
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