LiveCode Forums.

Hi,

I have a Data Grid that contains a "date" field (converted to dateItems) per row.
My problem is whenever I sort the datagrid by date, the dates are not sorted as ascending/descending as I wanted to.
For example: After sorting, I got:
2014,10,8,13,12,22,25
2014,12,25,9,13,5,26
2014,2,13,6,0,48,7
2014,2,13,6,52,48,2
2014,5,5,11,29,6,3
2014,5,5,3,12,36,37
...

While the correct ascending date should be:
2014,2,13,6,0,48,7
2014,2,13,6,52,48,2
2014,5,5,3,12,36,37
2014,5,5,11,29,6,3
2014,10,8,13,12,22,25
2014,12,25,9,13,5,26
...

I've tried using normal date and time records on that field, but the months could not be sorted accordingly Jan, Feb, Mar, ..., they will be sorted in alphabetical order instead.
Any advices on how to sort for date?

Thanks in advance!

I figured that I can convert the date and time to seconds instead of converting to dateItems...
The way should work

shoshinsha wrote:I figured that I can convert the date and time to seconds instead of converting to dateItems...
The way should work

Yes