sorting method in databands

[ajcervera]

Hi,

I am trying to get the data of a databand sorting by an element of type DATE (mm/dd/yyyy) but it seems that the sort method only work for text (and in this case,
it takes date as text too).

For example:

--> Obtained Result (mm/dd/yyyy):

01/06/2012
01/07/2013
03/02/2010
10/15/2011
12/16/2010


--> Expected Result (mm/dd/yyyy):

03/02/2010
12/16/2010
10/15/2011
01/06/2012
01/07/2013


Is there any way to get the sorting method that i need (sort the result by day, month and year) ?

Thanks in advance.

[Andrew]

Hello,

Could you, please send us .mrt file and database for reproducing the issue.

Thank you.

[ajcervera]

Sorry, but we realized that actually the type of ours elements is "string" instead of "datetime". This seems to be the reason.

Thanks a lot for your help.

[Andrew]

Ok! Thank you.