NewDateFormatter function for IBM Planning Analytics (TM1)

NewDateFormatter sets the date format used with ParseDate and FormatDate function.

In this video, NewDateFormatter will be used to get today’s date and time and convert it to Chicago and Melbourne time.

Where can the NewDateFormatter function be used?

TurboIntegrator

Which TM1 Server version is the NewDateFormatter function available for?

Version 11 and 12

What is the syntax for NewDateFormatter?

NewDateFormatter(Locale, TimeZone, UnixTime, FormatterStyle, TimeType)

Locale = local language
TimeZone = time zone
UnixTime = whether use Unix time or not
FormatterStyle = date format whether ‘full’, ‘long’, ‘medium’ or ‘short’
TimeType = type format whether ‘time’, ‘date’ or ‘datetime’

Relevant Functions

FormatDate = Formats a date value
NewDateFormatter = Sets the date format used with ParseDate and FormatDate function
ParseDate = Parses a date string according to a format defined with the NewDateFormatter function.