Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have date column in sql table like below
Oct 22 2008 12:00AM
I need to have date in qlikview application as 2008/10/22
Could anyone help me how to write in script.
Thanks
Try like:
Load
Date(Date#(FieldFromDB, 'MMM DD YYYY hh:mmTT'), 'YYYY/MM/DD') as NewDate
;
SQL Select
'''
From <>;
Try like:
Load
Date(Date#(FieldFromDB, 'MMM DD YYYY hh:mmTT'), 'YYYY/MM/DD') as NewDate
;
SQL Select
'''
From <>;
Hi
Try like this
Instead of Oct 22 2008 12:00AM -> Use your datefield
Date(Date#('Oct 22 2008 12:00AM','MMM DD YYYY hh:mmTT'),'YYYY/MM/DD')
Load
Date(Date#(FieldFromDB, 'MMM DD YYYY hh:mm TT'), 'YYYY/MM/DD') as New_Date;
SQL Select
'''
From <>;
This should work.
Thanks and it's working but I can able to see 2059/09/12 and 2069/19/01 and not able to see the date 29/09/2013 which exists in ly table. Please help in this
Thanks and it's working but I can able to see 2059/09/12 and 2069/19/01 and not able to see the date 29/09/2013 which exists in ly table. Please help in this
Ideally, there should have been a space before 'TT'. Try and let know if that was the issue.
Yup.
And thats what I posted.