Page History
9.28 CONVERTDATE
| Note | ||
|---|---|---|
| title |
Converts format of alphanumeric date.
Using the CONVERTDATE Built-In Function twice and producing 2 different result fields allows you to produce dates such as: THURSDAY 5TH OCTOBER 1987.
Arguments
No | Type | Req/ Opt | Description | Min Len | Max Len | Min Dec | Max Dec |
|---|---|---|---|---|---|---|---|
1 | A | Req | Date that is to be converted | 1 | 20 | ||
2 | A | Req | Format of date to be converted | 1 | 1 | ||
3 | A | Req | Format required of date in return value | 1 | 1 |
...
Convert a date field #YMD in date format YYMMDD (D) to date format DDMMYY (B) in field #DMY:
USE BUILTIN(CONVERTDATE) WITH_ARGS(#YMD D B) TO_GET(#DMY)