topic Re: Date Timestamp in QlikView

Date Timestamp

rustyfishbones — Tue, 29 May 2018 09:50:32 GMT

Hi All,

I have the following value - 2016-08-31 08:32:48:000 + 01:00

What is the best way to extract the date, I tried FLOOR and Date Function and it returns nothing.

I know I can try LEFT(DateTimeCreated,10) and that will return the date and I can then convert to DD/MM/YYYY instead of YYYY-MM-DD.

Any better methods to do this?

Thanks

Alan

Re: Date Timestamp

tresB — Tue, 29 May 2018 10:05:51 GMT

If you use left() - a string function, it might not give you a real date (number at the back-end). You should rather use parsing function date#() alongwith it like and then format using date():

Date(Date#(LEFT(DateTimeCreated,10), 'YYYY-MM-DD'), 'DD/MM/YYYY ')

Re: Date Timestamp

rustyfishbones — Tue, 29 May 2018 10:18:40 GMT

Thanks Tresesco