toDate
- Former user (Deleted)
- Eleanor Brodie
- Dominic Sandhu (Unlicensed)
- Chris Welford
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