ParseDate function for IBM Planning Analytics (TM1)

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.