Problem with data conversion from text to datetime

[#1]

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

[#2]

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