13.2 Date Formats
Date Built-In Functions may use one or more of the following formats as arguments and/or return values. The relevant Built-In Function's description tells you which format is used as arguments and/or return values.
Code | Format of Date | A | System date format | B | DDMMYY | C | DD/MM/YY | D | YYMMDD | E | YY/MM/DD | F | MMDDYY | G | MM/DD/YY | H | DDMMYYYY | I | DD/MM/YYYY | J | YYYYMMDD | K | YYYY/MM/DD | L | MMDDYYYY | M | MM/DD/YYYY | N | DDMMMYY (e.g. 03JUL87) | O | DDMMMYYYY (e.g. 03JUL1987) | P | DDxx MMMMMMMMM YY (e.g. 16TH SEPTEMBER 87) | Q | DDxx MMMMMMMMM YYYY (e.g. 16TH SEPTEMBER 1987) | R | DDD (e.g. MON, TUE, WED, etc). | S | DDDDDDDDD (e.g. MONDAY, TUESDAY, WEDNESDAY, etc). | T | DDDDDDDDDD (in selected language e.g. LLLLLLLLLL). | U | MMMMMMMMMM (in selected language e.g. LLLLLLLLLL). | V | 8 digit system date format | W | YYMM | X | MMYY | Y | YYYYMM | Z | MMYYYY | 1 | CYYMMDD | |