TODAY TM1 Function: Syntax and Use

TODAY simply returns the current system date as a string in the form ‘yy-mm-dd’, or if you want, in the format ‘yyyy-mm-dd’.

Syntax of TODAY

The syntax is Today ( FourDigitYearFlag); where:

  • FourDigitYearFlag – can be either omitted or 0 or 1, where omitted or 0 will return the 2 digit year and a 1 will return a 4 digit year.

Example

Assuming the current system date is 07 June 2016, then:

Today(1);

will return the string ‘2016-06-07′

While Today();

will return the string ’16-06-07’.

This function is valid in both TM1 rules and TurboIntegrator 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.
This entry was posted in Rule Functions, TI Functions and tagged today. Bookmark the permalink.