Regarding date format

[sushil353]

hi experts,

i am very new to qlikview, In my data base i have day_date like

15-AUG-10 12.00.00AM

but i want to show the date only as 15-aug-10

please help me how to do that and also tell me is decode and to_date functions are working in qlikview

Thanks

Sushil

[Miguel_Angel_Baeyens]

Hello Sushil,

Use the following format in the LOAD part

=Date(TimeStamp#('15-AUG-10 12.00.00AM', 'DD-MMM-YY hh.mm.ssTT'))

Hope that helps.

[ashfaq_haseeb]

hi Sushil

Yuo can user some thing like this

date(Date field) as Date,

hope this helps your problem

Regards

ASHFAQ

[sushil353]

THANKS

MIGUEL ANGEL