I’m using the pro version of dhtmlx and I’m look for a sorting solution of columns with a date. Following an example I have set the celltype to “ro” and sort to “date”. Using a date format “m/d/y” or “m/d/Y” sorting goes well. So, what I need is a date format like “d.m.y” or “d.m.Y”. If I set this format to my column, the sorting algorithm does not work anymore. Now I have two options: the content of my database is a UNIX-timestamp (int=10). This is the most effective way to sort tables within MySQL. I can add a column to my grid with this values (hidden). Is there an opportunity to sort a different column clicking on the date header line? or using the original column, how can I sort these items without using dhxCalendar or dhxCalendarA (this takes to much time).
a) you can use dhxCalendar column type and setDateFormat method - which will allow to show data in custom format and still able to sort it correctly
b) you can provide hidden column with necessary data ( or use row attributes to store the same data ) and use custom sorting function which will use it for sorting
Please chech “Predefined sorting order” at
dhtmlx.com/docs/products/dhtmlxG … d_art_sort