Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

how can i change Time Stamp (12/08/2017 00:00:00) to Date (12/07/2017)

Hi all,

i have Time stamp  field

Time Stamp
12/08/2017 00:00:00
12/08/2017 00:15:00
12/08/2017 00:42:00
12/08/2017 00:15:00
12/08/2017 00:15:00
12/08/2017 20:15:00
12/08/2017 23:15:00
12/08/2017 23:55:00
12/09/2017 00:00:00
12/09/2017 01:00:00
12/09/2017 02:10:00

by using  Time stamp i want to create Date like below table

Time StampDate
12/08/2017 00:00:0012/07/2017
12/08/2017 00:15:0012/08/2017
12/08/2017 00:42:0012/08/2017
12/08/2017 00:15:0012/08/2017
12/08/2017 00:15:0012/08/2017
12/08/2017 20:15:0012/08/2017
12/08/2017 23:15:0012/08/2017
12/08/2017 23:55:0012/08/2017
12/09/2017 00:00:0012/08/2017
12/09/2017 01:00:0012/09/2017
12/09/2017 02:10:0012/09/2017
1 Solution

Accepted Solutions
Highlighted

May be this

Date(Floor(TimeStamp - MakeTime(0, 0, 1))) as Date

Update: I basically subtracted 1 second from your timestamp so that 12/08/2017 00:00:00 becomes 12/07/2016 23:59:59 before we floor it to a date

View solution in original post

1 Reply
Highlighted

May be this

Date(Floor(TimeStamp - MakeTime(0, 0, 1))) as Date

Update: I basically subtracted 1 second from your timestamp so that 12/08/2017 00:00:00 becomes 12/07/2016 23:59:59 before we floor it to a date

View solution in original post