Timestamp to Date format

[innashna]

Hi,

I have the following timestamp format:

1604303491916

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:

2020-11-02 09:51:32

But my formula gives to me:

2020-11-01 07:11:55.

Can you please help me?

Thanks,

Inna

[MayilVahanan]

Hi @innashna 

Try like below

=date((1604303491916/24/60/60/1000 )+ 25569,'YYYY-MM-DD HH:mm:SS')
Minute must be in "mm" not "MM"

[innashna]

Hi,

the  minutes are correct now. But hour still shows 07 and not 09. It relates to timezone, right?

[MayilVahanan · Accepted solution]

Hi @innashna 

Yes, its might be relates to timezone. You can convert via ConvertToLocalTime()

FYIP: