order date list box

[#1]

Hi,

i'm trying to load table file from xls containing several date(about 7000).

I create a list box and i want to arrange date correctly(from past to present)

I tried changing sort option with sort by, but doesn't work properly(see attached qvw file)

Can anyone suggest any solution?

Thank's

Diego

[#2]

Hi,

Use this code in the script and sort the field by number from sort tab.

date(date#(DATE,'DD/MM/YYY'),'DD/MM/YYY') as DATE

- Sridhar

[#3]

HI Diego,

change your load script into:

LOAD DATE(DATE) AS DATE
FROM  (biff, embedded labels, table is Sheet1$);

Then it should work (see attachment)

[#4]

HI Sridhar,

thank u for your reply;

I 've tried to write this code in the script

LOAD date(date#(DATE,'DD/MM/YYY'),'DD/MM/YYY') as DATE

But i get no data or error.

See attachement for detail.

bye