Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kavieweg
New Contributor II

Timestamp to Date

Hi togehter,

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

1504190905447

Time.PNG

1 Solution

Accepted Solutions

Re: Timestamp to Date

May be this

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

2 Replies

Re: Timestamp to Date

May be this

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

arunaerra
Contributor

Re: Timestamp to Date

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,

Community Browser