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:## parameter in the 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 (see XTF_SORT) 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

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.