DATS format Charcteristic IO sorting issue in the Workbook

23 Views

Hi Experts,

I have one Characteristic of type DATS. In the Query it was given Ascending option in the properties. In the initial display of the results it shows correctly. If i try descending option in Excel its not giving correct result.

For e.g:

Initial result:

'9/13/2007

'9/18/2007

'12/13/2007

'7/10/2008

'12/2/2009

After sorting Z-A standard functionality in Excel:

'9/18/2007

'9/13/2007

'7/10/2008

'12/2/2009

'12/13/2007

I have observed that BEx is adding single quote 'for all the date values as it is a characteristic InfoObject. I feel that is causing problem when I sort. If it is one time we can remove the quotes, but everytime when we run the query we will be facing same problem.

I tried changing the format of the cells in Excel but didn't work.

Can anyone help me?

Edited by: sree uk2004 on Nov 20, 2008 9:41 PM