Discussion Board for collaboration related to QlikView App Development.
I have the following timestamp format:
I need to convert it to : 'YYYY-MM-DD HH:MM:SS'.
I used the following formula:
date(([timeStamp]/24/60/60/1000 )+ 25569,'YYYY-MM-DD HH:MM:SS')
It gives incorrect hour.
It should be:
But my formula gives to me:
Can you please help me?
Yes, its might be relates to timezone. You can convert via ConvertToLocalTime()
View solution in original post
Try like below
=date((1604303491916/24/60/60/1000 )+ 25569,'YYYY-MM-DD HH:mm:SS')Minute must be in "mm" not "MM"
the minutes are correct now. But hour still shows 07 and not 09. It relates to timezone, right?