topic Regarding date format in QlikView

Regarding date format

sushil353 — Mon, 21 Mar 2011 11:38:09 GMT

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 — Mon, 21 Mar 2011 11:40:42 GMT

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 — Mon, 21 Mar 2011 11:41:01 GMT

hi Sushil

Yuo can user some thing like this

date(Date field) as Date,

hope this helps your problem

Regards

ASHFAQ

sushil353 — Tue, 22 Mar 2011 05:03:36 GMT

THANKS

MIGUEL ANGEL