topic Problem with data conversion from text to datetime in QlikView https://community.qlik.com/t5/QlikView/Problem-with-data-conversion-from-text-to-datetime/m-p/175374#M43842 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P>I was able to solve my problem.</P><P>I have changed my webservice to return only date ,instead of datetime.</P><P>I was able to perform my date conversions on that field ,Say HIRE_DT.</P><P>My app looks fine.</P><P>Thanks,</P><P>Srihari</P></BODY></HTML> Wed, 10 Nov 2010 06:50:07 GMT 2010-11-10T06:50:07Z Problem with data conversion from text to datetime https://community.qlik.com/t5/QlikView/Problem-with-data-conversion-from-text-to-datetime/m-p/175373#M43841 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>I am using a webservice in the load script to load the data into the qlikview file.</P><P>I am having a date field HIRE_DT .</P><P>I need to convert this field to datetime as a webservice XML returns only text.</P><P></P><P>Tried Using :</P><P>date</P><P></P><P>(date#(HIRE_DT,'DD-MM-YYYY')) <B>as</B> date1,</P><P>with no luck.</P><P></P><P>Please suggest</P><BR /><BR /></BODY></HTML> Mon, 08 Nov 2010 14:00:47 GMT https://community.qlik.com/t5/QlikView/Problem-with-data-conversion-from-text-to-datetime/m-p/175373#M43841 2010-11-08T14:00:47Z Problem with data conversion from text to datetime https://community.qlik.com/t5/QlikView/Problem-with-data-conversion-from-text-to-datetime/m-p/175374#M43842 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P>I was able to solve my problem.</P><P>I have changed my webservice to return only date ,instead of datetime.</P><P>I was able to perform my date conversions on that field ,Say HIRE_DT.</P><P>My app looks fine.</P><P>Thanks,</P><P>Srihari</P></BODY></HTML> Wed, 10 Nov 2010 06:50:07 GMT https://community.qlik.com/t5/QlikView/Problem-with-data-conversion-from-text-to-datetime/m-p/175374#M43842 2010-11-10T06:50:07Z