Date format for effective sorting?
I'm using the date format of mm/dd/yyyy but it seems to sort by the mm/dd only, I cannot get the year to be taken into consideration when sorting by date.
Or do I need to declare a date format in the code itself?
<!-- sort value -->display value so your date cell contents would be
<!-- 2004/09/01 -->01/09/2004
Assuming the sort works on the entire cell contents this should work. Although with a little bit of a download performance hit.
Basically grid uses data/text property for display and data/value for sorting. By default data/value = data/text and sorting procedure tries to guess if the value is string or number. It works well only in most simple cases, othervise you have to either send both text and value arrays or provide function which converts text to value (or value to text).
This topic is archived.
Back to support forum
Version 2Looking for AW 2.6 ?
The old site is here.