Date ascending or descending order

[#1]

Hello,

I have an excel file (*.csv) which has one filed that contains timestamp values Ex. 07/21/2011 16:40:43, etc...

Now i have manged to convert into Date format 'MM/DD/YYYY'.

Chart Dimension: Date(Date#(Left([Event Timestamp],10),'MM/DD/YYYY'),'MM/DD/YYYY')

But how can i sort above dimension by ascending/descending order? I have tried several option using Sort tab but no luck.

Any idea?

Thanks,

Dinesh

[its_anandrjs]

Hi dpatel, J.L.Dengra,

Use expression in the Sort properties like

Date(Date#(Left([Event Timestamp],10),'MM/DD/YYYY'),'MM/DD/YYYY') and what ever your expression use the expression and select Descending and Ascending order to sort the chart.

Rgds

Anand