Date sort with tSort.

[Anonymous]

Hi.
I try to data sort with tSort, but it isn't worked that I expected.
sort Key is Date.
I expected output;
Date
--------------
2014-05-01
2014-05-02
2014-05-03
2014-05-04
2014-05-05
2014-05-06
2014-05-07
:
:
2014-05-30
2014-06-01
2014-06-02
2014-06-03
2014-06-04
2014-06-05
:
2014-06-26

I got result;
Date
--------------
2014-06-01
2014-06-02
2014-06-03
2014-06-04
2014-06-05
:
2014-06-26
2014-05-01
2014-05-02
2014-05-03
2014-05-04
2014-05-05
2014-05-06
2014-05-07
:
:
2014-05-30

How do I do?

I attach the setting image. now i have three sort key. other key works fine.

Thanks.

[Anonymous]

Whether you are sorting date column ascending or descending? could not identify because the char is Chinese.
What is the default data type of date column inside metadata?
Vaibhav

[Anonymous]

Hi Miki Kamijo,
If you want to sort the date column, first convert the column to string type then use tSortRow.
Then again convert the sorted column of string type to date.
Thanks,
Bhanu.