Syntax
ASDATE(<date string>;<optional data parse pattern>)
Description
Converts a character sequence to a date using either a predefined (dd-MM-yyyy hh:mm:ss, dd.MM.yyyy hh:mm:ss, dd-MM-yyyy, dd.MM.yyyy) or a custom date parse pattern.
For further details about date and time parse patterns please refer to Using Date and Time Patterns
Examples
Column1 | Date parse pattern | ASDATE returns |
|---|---|---|
19-01-2008 11:13:27 | dd-MM-yyyy hh:mm:ss | Sep, 19 2008 11:13:27 AM |
25.09.05 12:23:05 | dd.MM.yy hh:mm:ss | Sep, 25 2005 12:23:05 PM |
15-10-2002 | dd-MM-yyyy | Oct, 15 2002 12:00:00 AM |
06.11.2010 | dd.MM.yyyy | Nov, 25 2010 12:00:00 AM |
2011-05-04 | yyyy-MM-dd | May, 04 2011 12:00:00 AM |
| 2009-06-30T18:30:00.001 | yyyy-MM-dd'T'HH:mm:ss.SSS | Jun 30, 2009 06:30:00 PM |
...