Can't parse a timestamp in Qliksense

[johnnyjohn]

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]

Hi 

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')