topic Re: Can't parse a timestamp in Qliksense in App Development

Can't parse a timestamp in Qliksense

johnnyjohn — Thu, 02 Sep 2021 10:31:29 GMT

I have the following timestamp format:

When I load it in Qliksense without any manipulation, it seems to be read fine as a timestamp.

But any manipulation I try to do on the date does not work

Could someone help please?

brunobertels — Fri, 03 Sep 2021 14:46:29 GMT

tru this

to get date :

date(floor(timestamp#(left('20210902 09:01:15.811790 +0100s',17),'YYYYMMDD hh:mm:ss')),'DD/MM/YYYY')

to get time :

time(right(timestamp#(left('20210902 09:01:15.811790 +0100s',17),'YYYYMMDD hh:mm:ss'),8),'hh:mm:ss')