How to: |
There are six DT functions. Each one converts a number into a date of a different format.
function(number, output_format)
where:
Is one of the following:
Integer
Is the number of days since 'base' date, possibly received from the functions DAxxx.
I8xxx, where xxx corresponds to the function DTxxx, for example I8DTDMY.
The output format is determined by the specified function (that is, DTDMY, DTDYM, DTMDY, DTMYD, DTYDM, or DTYMD).
DTMDY converts NEWF (which was converted to the number of days by DAYMD) to the corresponding date and stores the result in a column with the format I8MDYY.
DTMDY(NEWF, 'I8MDYY')
For 81/11/02, the result is 11/02/1981.
For 82/05/01, the result is 05/01/1982.
iWay Software |