Function group | Execute on client | Platform(s) |
---|---|---|
Date and Time | YES | All |
dat(datestring|number[,dateformat])
Converts a datestring or number to a date value using an optional dateformat string and returns the result. JavaScript client-executed methods do not support number.
If you do not specify a dateformat, the first argument is converted using #FD. You can use the following symbols in the dateformat string:
Y | Year (03) | d | Day (12th) |
y | Year (2003) | W | Day of week (5) |
C | Century (20) | w | Day of week (Friday) |
M | Month (06) | V | Short day of week (Fri) |
m | Month (JUN) | E | Day of year (1-366) |
n | Month (June) | G | Week of year (1-52) |
D | Day (12) | F | Week of month (1-6) |
Calculate lDate as dat('May 8th, 03')
# returns '8 MAY 03' if #FD = 'D m Y'
Calculate lDate as dat('May 8th, 2003','MDY')
# returns 050803
Calculate lDate as dat(91,'w, d n, y')
# returns 'Monday, 1st April, 1901' i.e. the 91st day of 1901