Timestamp to Date

[kavieweg]

Hi togehter,

how can I make a date and time from a timestamp like this:

1504190905447

[sunny_talwar · Accepted solution]

May be this

=TimeStamp(MakeDate(1970) + (1504190905447/(24*60*60*1000)))

[Anonymous]

Hi,

For day and month name u can do like below

TimeStamp(MakeDate(1970) + (1504190905447/(24*60*60*1000)),'WWW')&'  '&

TimeStamp(MakeDate(1970) + (1504190905447/(24*60*60*1000)),'MMM DD YYYY hh:mm:ss') AS DATE,