NOW() TM1 Function: Syntax and Use

The NOW function returns the current date-time stamp from the TM1 server as a serial number. In other words the number of days since the start of TM1 time. Note that this number will be dependent on your setting for UseExcelSerialDate in TM1s.cfg.

Syntax of NOW

The syntax is Now();  There are no arguments.

Usage

Typically Now(); will be used to store the current time in a numeric variable and then this will be addressed through other functions. For example

nTimeNow = Now();

will store the current date-time stamp from the server in the variable nTimeNow.

Therefore, assuming you have enabled UseExcelSerialDate in tm1s.cfg, this will return the same value as the now() function in Excel.

The TODAY Function

The TODAY function is similar but returns today’s date as a text string. See this post for more information on it.

Notes

Now() can be used in both Rules and TM1 Turbo Integrator Processes.

If you like this post, please spread the love…

About John

Managing Director of Infocube. We are a management accounting consultancy that specialises in Business Analytics.

One comment on “NOW() TM1 Function: Syntax and Use

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.