| Control Object Properties |
|
|
|
| Description | This
property is used to control the sorting of grid columns
when a sort by date is required. Normally when the Grid
sorts columns it does so either by a numeric value
comparsion or a string compare. If however the column
contains a date you need to tell the system the format of
the date being provided so it can determine which value
is the year, month or day respectively. The SortColFmt$ property is used to control the sorting of date columns. This property can be set to from one to three characters long where each character can be a "Y', 'M', or 'D' indicating the order of the data in the column. (Lowercase 'y, 'm', or 'd' are also supported) For example if the date is of the form day, month, then year, the 'SortColFmt$ property should be set to "DMY". If this field is not set, no special consideration will be given to date sorting. The 'SortColFmt property works in conjunction with the 'Column or 'Colno property to identify the column to which date sorting will be applied.. |
| Default | The default value is "" (no date sorting) |
| Used by | GRID |