TM1 Function for TI, FormatDate

Formats a date value

What is the FormatDate function?

FormatDate formats a date value

Where can the FormatDate function be used?


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’)

A demonstration on how to use FormatDate

Use FormatDate to return the date value for 18000.