Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How can I extract Date and Time from Timestamp?

Hello,

Attached is the format of the data in Excel:

I need to Extract Date and Time as separate fields.

I used this:

Timestamp("Changed Time Stamp",'D/MM/YYYY hh:mm:ss TT')

But am still not able to pull out date separately.

What can I use to get Date as its own and Time as its own?

1 Solution

Accepted Solutions
Highlighted

Re: How can I extract Date and Time from Timestamp?

May be this:

Date(Floor([Changed Time Stamp])) as Date,

Time(Frac([Changed Time Stamp])) as Time

View solution in original post

3 Replies
Highlighted

Re: How can I extract Date and Time from Timestamp?

May be this:

Date(Floor([Changed Time Stamp])) as Date,

Time(Frac([Changed Time Stamp])) as Time

View solution in original post

Highlighted
MVP
MVP

Re: How can I extract Date and Time from Timestamp?

For more information, have a look at

QlikView Date fields

(applies also to timestamps)

Why don’t my dates work?

Get the Dates Right

Highlighted
Creator II
Creator II

Re: How can I extract Date and Time from Timestamp?

Correct Answer

I have executed