FormatDate function for IBM Planning Analytics (TM1)
FormatDate formats a date value.
In this video, FormatDate will be used to return the date value for 18000.
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.