topic Convert to text date to date in QlikView

Convert to text date to date

Thu, 19 May 2011 08:39:15 GMT

Hello,

I want to convert the following date (getting as text from database) to date format as 'YYYY-MM-DD': "2009-12-18T10:30:38.000Z".

Following command is not working because it is a text:

date('2009-12-18T10:30:38.000Z', 'YYYY-MM-DD');

Thanks

Samir

Convert to text date to date

Thu, 19 May 2011 08:54:26 GMT

date(date#(myDate,'YYYY-MM-DD hh:mm:ss.fff),'YYYY-MM-DD')
It's possible that you have to loose the T and Z since that can't be found in documentation.

Convert to text date to date

kaushalview — Thu, 19 May 2011 09:00:48 GMT

Hi,

Samir

Try this its working

=date(makedate(left('2009-12-18T10:30:38.000Z',4),mid('2009-12-18T10:30:38.000Z',6,2),mid('2009-12-18T10:30:38.000Z',9,2)),'YYYY-MM-DD')

regrads

Kaushal mehta