Help in date

[vinod22kv]

Hi,

I have date as Bellow. if i use text object with date(43466,'DD/MM/YY')  Its working fine. if i use it in list object (date(Date,'DD/MM/YY')) its not working may i know why?

Date
43466
43467
43468
43469
43470
43471
43472
43473
43474
43475
43476
43477
43478
43479
43480

Thanks and Regards,

Vinod

[poonam_kulwal]

Hi Vinod,

You cannot use Date field as it is in list box.
Crete a list box with expression "=date(Date,'DD/MM/YY')".

It should work.

Regards,

Poonam

[rubenmarin]

Hi, it's working for me (sample attached), can you post a sample where it doesn't works?

[vinod22kv]

Hi i am trying to do cross table with date

[vinod22kv]

Please find the data

[rubenmarin · Accepted solution]

You don't need crossstable with this excel and dates loads ok.

In date test.qvw all dates are loaded as text, not dates or numbers, you can load from resident to create the dates adding:
LOAD *,
Date(Num#(Date)) as Date InDateFormat
resident [TableName];

DROP [TableName];