FormatDate function for IBM Planning Analytics (TM1)

Where can the FormatDate function be used?

Which TM1 Server version is the FormatDate function available for?

What is the syntax for FormatDate?

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