Dates and Time in TM1

15 min total time

10 articles

3 authors

Start Reading

Playlist

Dates and Time in TM1

This series focusses on the manipulation and use of date and time in TM1 and Planning Analytics. We cover not only the functions, but also how to set your TM1 model to use the same date system as Excel and how to set your logs to use local time as well.

10 posts - 3 authors

Rule Functions | TI Functions

YEAR Function in TM1: Syntax and Use

The YEAR function in TM1 allows us to extract the number representing the Year from a date. Here we...

Rule Functions | TI Functions

MONTH Function in TM1: Syntax and Use

The MONTH function in TM1 allows us to extract the number representing the Month from a date. Here...

Excel Reports | TM1 Management | tm1s.cfg

How to Use Excel Dates as Serial Dates in TM1

TM1 and Excel can now share the same serial date system by the use of UseExcelSerialDate=T in your...

Rule Functions | TI Functions

How to Convert a Numeric Date to a String using the DATE Function in TM1

The Date Function in TM1 converts a serial date from a number to a string. For example Date(13947 ,...

Rule Functions | TI Functions

TODAY TM1 Function: Syntax and How to Use

The TODAY function returns today’s date in a text string and allows you to define the year as...

Rule Functions | TI Functions

How to Convert a String Date to a Numeric Date in using the DayNo TM1 Function

Here we are going to explain how to use the DAYNO TM1 function to convert a date as a string into a...

Rule Functions | Rules | TI Functions

NOW() TM1 Function: Syntax and Use

The now() function returns a value corresponding with the number of days from either 1 January 1960...

TI Best Practices | TI Functions

Date and Time Functions for Easy Date Manipulation

Manipulating dates and times in TM1 has always been horrible. Here we discuss the time manipulation...

Logging | TM1 Management

Changing TM1 Server Log Time Zone Stamp

Ever wondered how to set TM1 logging to use local time, rather than GMT (UTC)? Here's how to set...

Creating and Expanding a Time Dimension

This post should really be titled “Creating a Time Dimension with a method which allows it to...