NewDateFormatter function for IBM Planning Analytics (TM1)

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.