Displaying DATE of text format in descending order (1 Viewer)

[Jigs]

Hi All,

I have a field named "PICK_DATE" in text format where pickup date is stored in DD/MM/YYYY format.

Now I wanted to generate a report with the order by clause of PICK_DATE. But it is not giving me the desired result. I want to see the latest PICK_DATE at the top of the report in desending order.

Can any one pls help me out to solve this problem ?

Thanks in advance,

Jignesh

 

[Mile-O]

Use the CDate() function on the field and sort on that.

 

[Jigs]

it gives Invalid Use of Null

I am using the following queries:

SELECT ORDERNO, ORDERDATE, CDATE(PICK_DATE) FROM TRAVELS ORDER BY PICK_DATE

Above query doesn't give the desired result.

But when I use

SELECT ORDERNO, ORDERDATE, CDATE(PICK_DATE) FROM TRAVELS ORDER BY CDATE(PICK_DATE)

it gives the error : INVALID USE OF NULL

Can any one pls help me to sort this problem out ?

Thanks in advance,

Jigs

 

[Rich]

Use the sorting option on the Report toolbar