Page 1 of 1

sorting method in databands

Posted: Mon Aug 09, 2010 3:17 am
by 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.

sorting method in databands

Posted: Mon Aug 09, 2010 4:58 am
by Andrew
Hello,

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

Thank you.

sorting method in databands

Posted: Mon Aug 09, 2010 6:33 am
by 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.

sorting method in databands

Posted: Mon Aug 09, 2010 7:49 am
by Andrew
Ok! Thank you.