topic Re: convert to date format YYYY/MM/DD? in QlikView

convert to date format YYYY/MM/DD?

Thu, 18 Feb 2016 15:38:21 GMT

Date(Date#(Subfield(created_time,'-',1) &'/'& Subfield(created_time,'-',2) &'/'& Subfield(created_time,'T',3) ,'YYYY/MM/DD'),'YYYY/MM/DD')as [newdate],

This is not working.

Re: convert to date format YYYY/MM/DD?

sunny_talwar — Thu, 18 Feb 2016 18:18:07 GMT

May be this:

Date(Date#(Left(created_time, 10), 'YYYY-MM-DD'), 'YYYY/MM/DD') as NewDate

Re: convert to date format YYYY/MM/DD?

Gysbert_Wassenaar — Thu, 18 Feb 2016 18:19:30 GMT

Maybe like this:

Date(Floor(Timestamp#(created_time, 'YYYY-MM-DDThh:mm:ss+ffff')),'YYYY/MM/DD')

If not, please post a source data file.

Re: convert to date format YYYY/MM/DD?

Thu, 18 Feb 2016 18:31:57 GMT

Thank you

Re: convert to date format YYYY/MM/DD?

Thu, 18 Feb 2016 18:32:10 GMT

Thank you