Function: toDate()

Converts a standard PhixFlow date string (e.g. 20120521 or 20120521.172108) into a true date, or a non-standard date string into a true date if supplied with a format pattern.

Returns the date if dateString is a true date.

Returns null if dateString is null.

Beware of daylight savings clock changes! In countries where daylight savings are applied, at the point of the year when the clocks go forward, a hour will be lost. If you have a date and time that happen to fall into this missing hour, when you run a toDate() on the value, you will get an error like

failed: Unable to convert the string "26/03/2017 01:00:15" into a date. Valid formats include dd/MM/yyyy, dd/MM/yyyy HH:mm:ss

Syntax

toDate(dateString)

toDate(dateString, formatString)

Argument	Type	Description
dateString	String	String to be converted into a date.
formatString	String	Optional argument that which allows for a Date and Time Format Patterns to represent the format of dateString.

Examples

toDate("20100714")

Returns the date 14/07/2010.

toDate(in.ChargeDate,"yyyy/MM/dd HH:mm:ss")

where in.ChargeDate has the value "2002/12/09 09:03:42", returns the date/time 09/12/2002 09:03:42

toDate(in.ChargeDate,"yyyy MMM d, HH-mm-ss")

where in.ChargeDate has the value "2002 Dec 9, 09-03-42", returns the date/time 09/12/2002 09:03:42

toDate("2010.July.04 AD 12:08 PM","y.MMM.d G h:m a")

Returns the date/time 04/07/2010 12:08:00

PhixFlow 7.6 Help

toDate

Function: toDate()

Syntax

Examples

See Also