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.