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’.

The NOW Function

if you’re looking to understand the NOW function, where you can get a numeric serial number for today’s date, please see this post.

Notes

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.

One comment on “TODAY TM1 Function: Syntax and Use

Leave a Reply

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