Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I am using a webservice in the load script to load the data into the qlikview file.
I am having a date field HIRE_DT .
I need to convert this field to datetime as a webservice XML returns only text.
Tried Using :
date
(date#(HIRE_DT,'DD-MM-YYYY')) as date1,
with no luck.
Please suggest
Hi everyone,
I was able to solve my problem.
I have changed my webservice to return only date ,instead of datetime.
I was able to perform my date conversions on that field ,Say HIRE_DT.
My app looks fine.
Thanks,
Srihari