Year is not considered while sorting Date Column in Grid

Suite and Optimus Suite 5
#1

Hi Team,

We have Date column in Grid and its having ‘MM/DD/YYYY’ format. When we sort Date Column, its sorted in the order of ‘MM/DD’ and year is not considered. Is there any solution to get the date sorted by considering MM/DD/YYYY.

For Example, We having three Data in Date Field and they are
01/02/2013
05/04/2013
02/02/2014
And on Sorting we are getting the following Result:
01/02/2013
02/02/2014
05/04/2013
Expected Result:
01/02/2013
05/04/2013
02/02/2014

Regards,
Sreelakshmi

#2

Hello
are you using custom sorting method or default?

http://docs.dhtmlx.com/doku.php?id=dhtmlxgrid:sorting

#3

Please, clarify what exCell type do you have in your date column and what sorting type you are using.

For date sorting you may use the sorting type “date”. It should work correctly with dates “mm/dd/yyyy”.

#4

Thanks team :smiley: .Did the same and my issue is fixed now!