Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field from a SQL data load called po.created_date. This field is formatted as YYYY-MM-DD HH:MM:SS.
I just want the date from this field. How can I do this in the script?
try in QLik script
date(date#(Field,'YYYY-MM-DD HH:MM:SS'),'DD-MM-YYYY') as YourDate
try in QLik script
date(date#(Field,'YYYY-MM-DD HH:MM:SS'),'DD-MM-YYYY') as YourDate
try Date(floor(Num(YourDateField)), 'DateFormat')
or
date(date#(po.created_date,'YYYY-MM-DD HH:MM:SS'),'Here your Date format') as po.created_dateNew
Hi try with :
load
timestamp(timestamp#(po.created_date,'YYYY-MM-DD hh:mm:ss'),'DD/MM/YYYY hh:mm:ss')
this also worked, thank you
this also worked, thank you
this also worked, thank you