ParseDate function for IBM Planning Analytics (TM1)
ParseDate parses a date string according to a format defined with the NewDateFormatter function.
In this video, ParseDate will be used to parse the date ‘2020-04-22’, according to the format ‘yyyy-MM-dd’.
Where can the ParseDate function be used?
TurboIntegrator
Which TM1 Server version is the ParseDate function available for?
Version 11 and 12
What is the syntax for ParseDate?
ParseDate (DateString, <Pattern>, <index>)
- DateString = A date string to be parsed
- Pattern = Pattern used for parsing dates
- Index = Index returned by a call to the NewDateFormatter function. If no date formatter exists, then this is called
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.