{"id":9669,"date":"2016-02-22T09:36:17","date_gmt":"2016-02-22T01:36:17","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=9669"},"modified":"2024-01-17T10:48:04","modified_gmt":"2024-01-17T02:48:04","slug":"parsedate","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/parsedate\/","title":{"rendered":"ParseDate()"},"content":{"rendered":"\n

Format<\/span><\/h2>\n

ParseDate(StringTime [,FormatString])<\/strong><\/p>\n

Returns<\/span><\/h2>\n

Returns the time that is the result of parsing the provided String\u00a0argument.<\/p>\n

Inputs<\/span><\/h2>\n

StringTime<\/strong>: The time expressed as a string.
\nBehaviour: Required
\nDimension: Collection, SingleValue, MultiCollection
\nValid\u00a0data types:\u00a0String<\/p>\n

FormatString<\/strong>: The expected format of StringTime\u00a0<\/em>according to the Format Codes table below. \u00a0If this\u00a0is not specified, StringTime<\/em> is assumed to be in ISO format.\u00a0The spacing of the FormatString parameter must exactly match that of the StringTime<\/em> parameter, including spaces.
\nBehaviour:\u00a0Optional
\nDimension: Collection, SingleValue
\nValid data types: String<\/p>\n

How to format data types<\/a><\/p>\n

Format Codes<\/h2>\n\n\n\n\n\n\n\n\n\n\n
YYYY<\/strong><\/td>\nFour-digit year<\/td>\n<\/tr>\n
YY<\/strong><\/td>\nTwo-digit year (00 to 99, from 2000)<\/td>\n<\/tr>\n
IY<\/strong><\/td>\nTwo-digit year (00 to 99, from 2000)<\/td>\n<\/tr>\n
MM<\/strong><\/td>\nTwo-digit month (01 to 12)<\/td>\n<\/tr>\n
DD<\/strong><\/td>\nTwo-digit day of month (01 to 31)<\/td>\n<\/tr>\n
HH<\/strong><\/td>\nTwo-digit hour (00 to 23)<\/td>\n<\/tr>\n
MI<\/strong><\/td>\nTwo-digit minute (00 to 59)<\/td>\n<\/tr>\n
SS<\/strong><\/td>\nTwo-digit seconds (00 to 59)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Examples<\/span><\/h2>\n

Expression:\u00a0ParseDate(\"2007-12-31T15:00:00+00:00\")<\/span>
\nResult:\u00a0Produces the UTC seconds since 1970 of this time.<\/p>\n

Expression: ParseDate(\"01 01-01-1970\", \"MI DD\/MM\/YYYY\u201d)<\/span>
\nResult:\u00a0Returns an error because the hour is not specified in the FormatString pattern.<\/p>\n

Expression:\u00a0ParseDate(\"01-01-2007 00:00:01\", \"DD\/MM\/YYYY HH:MI:SS\")<\/span>
\nResult:\u00a0Returns an error because the StringTime argument uses dashes to separate the year, month and day, but the FormatString pattern uses slashes.<\/p>\n

Release History<\/span><\/h2>\n