FormatDate function for IBM Planning Analytics (TM1)

Where can the FormatDate function be used?

TurboIntegrator

Which TM1 Server version is the FormatDate function available for?

Version 11 and 12

What is the syntax for FormatDate?

FormatDate(Date, Pattern, Index)​

• Date = date value​
• Pattern = pattern used for formatting dates, If empty, then it’s based on the FormatterStyle and FormatterType parameters used with the NewDateFormatter function.​
• Index = index returned by a call to the NewDateFormatter function. If blank, then the default is​
• NewDateFormatter(”, ‘Etc/UTC’, ‘serial’, ‘medium’, ‘date’)

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.