Page History
9.28 CONVERTDATE
| Note |
|---|
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 |
...
Date to be converted: A, B, C, D, E, F, G, H, I, J, K, L, M, V, W, X, Y, Z and 1.
Date to be returned: A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, R, S, T, U, V, W, X, Y, Z and 1.
Refer to Date Formats
Return Values
No | Type | Req/ Opt | Description | Min Len | Max Len | Min Dec | Max Dec |
|---|---|---|---|---|---|---|---|
1 | A | Req | Returned converted date | 1 | 20 | ||
2 | A | Opt | Return code (Y or N) for successful conversion | 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)