This function converts a value into a date time representation. Changes from text values using standard US English formatting (Decimal numbers must use . as the decimal separator).
DateTime([Value])
Where:
Value is the Date/Time code for the date/time to be returned
| Rule | Meaning |
|---|---|
| DateTime(40631+30) | Will return 28/04/2011 (or 04/28/2011 for US type formatting). |
| DateTime(DWVariableDate+20.5) | Will return 18/04/2011 12:00:00 or (04/18/2011 12:00:00 for US type formatting) when DWVariableDate is 40631 |