Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

parseDate(format, date_as_string[, locale_as_string])

Description

Excerpt

Returns the parsed date according to the format you provided. If parse fails, it will return a null date.

Parameters

Parameter name

Type

Required

Description

format

string

Yes

Valid Java format, as defined here: http://docs.oracle.com/javase/6/docs/api/java/text/SimpleDateFormat.html.

date_as_stringstringYesString which represents the date.
locale_as_stringstringNo

Language tag which should be used to parse a date. It can be leveraged to parse dates like this: 5/фев/18.

This parameter accepts well-formed BCP 47 language tag. See this link for more details on possible values.

Return type

date

Example

Code Block
print("(1) Parsed date is:" + parseDate("yyyy.MM.dd", "2000.01.01"));       // returns a valid date
print("(2) Parsed date is:" + parseDate("yyyy.MM.dd", "2000/01/01"));       // returns an empty date (null)

...

)
print("(3) Parsed date is:" + parseDate("dd/MMM/yy", "5/фев/18", "ru-RU")); // returns a valid date which is parsed using ru-RU locale


See also

Filter by label (Content by label)
showLabelsfalse
max100
showSpacefalse
cqllabel = "date_routines"
labelsdate_routines