topic Re: Converting timestamp to date issue in QlikView

Converting timestamp to date issue

Tue, 08 Nov 2016 00:18:36 GMT

Please guys I have a problem.

I have this timestamp format '2016-11-01 00:01:00.0000000 +00:00' and I want to convert it to date format.

Thank you

tamilarasu — Tue, 08 Nov 2016 04:15:15 GMT

Hi Lou,

Date(Date#(SubField(FieldName, ' '),'YYYY-MM-DD'),'YYYY-MM-DD')

hemanthaanichet — Tue, 08 Nov 2016 04:42:20 GMT

Hi Lou,

date(date#(FieldName),'YYYY-MM-DD'),'YYYY-MM-DD')

Regards

Hemanth

jonathandienst — Tue, 08 Nov 2016 04:47:29 GMT

=Date#(SubField(FieldName, ' ', 1),'YYYY-MM-DD') // date in ymd format

=Date(Date#(SubField(FieldName, ' ', 1),'YYYY-MM-DD')) // date in the default format for your system

Tue, 08 Nov 2016 09:20:59 GMT

Thank you Jonathan, it works