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.
After sorting Z-A standard functionality in Excel:
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