Standard Date Format
cformat switch: D
MM/DD/{CC}YY format or DD/MM/{CC}YY format, depending on language definition. Supports quite a bit of flexibility in formats, including dates with other delimiters (e.g. 12-31-06), no delimiters (e.g. 12312006), as well as dd-mon-{cc}yy format (e.g. 12-dec-2006). If a two digit year is specified, XTREE uses the SBR=CCYY in miame.ini for determining the century. The default value is equivalent to SBR=CCYY:60, meaning that any YY value of 60 or higher is assumed to 19YY; otherwise it is assumed to be 20YY.
Note that there is no internal validation or formatting logic associated with the D cformat code. Its purpose is solely to inform the sorting routine so that it can interpret the column data to be able to effectively sort it in chronological order. For editable date columns, the only way to enforce a consistent format is to use the Advanced Coldef Options InfDef=D and Format=<format string>, which cause the Windows date/time picker control to be used for editing.
History
2023 June, A-Shell 6.5.1733: Coldef "D" now recognizes SQL DATE and DATETIME formats CCYY-MM-DD {HH:MM{:SS}}. Previously they didn't sort properly. Note that if all the cells in the column are in that format, sorting will work with coldef "S" (string), but date filtering would not.
2008 May, A-Shell 5.1.1113: Date columns that include both a date and a time (e.g. "25-May-08 08:25 PM") will now be sorted taking both into account.
