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.

Rule Functions | Rules | TI Functions | Turbo Integrator

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

Read

Rule Functions | Rules | TI Functions | Turbo Integrator

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

Read

Rule Functions | Rules | TI Functions | Turbo Integrator

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

Read

Administration | Excel Reports | Reporting | 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...

Read

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

Read

TODAY TM1

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

Read

Rule Functions | Rules | TI Functions | Turbo Integrator

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

Read

Time Zone

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

Read

Rule Functions | Rules | TI Functions | Turbo Integrator

NOW() TM1 Function: Syntax and Use

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

Read

Administration | Training

Creating and Expanding a Time Dimension

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

Read