Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
hi Sushil
Yuo can user some thing like this
date(Date field) as Date,
hope this helps your problem
Regards
ASHFAQ
THANKS
MIGUEL ANGEL