Convert Timestamp to Date field and Hour Field.

[neena123]

Hello! 

How do I convert this timestamp 5/1/2020 15:02:54.123 to just a Date field: 5/1/2020 and hour field to round off to just say 9,10,11,12,13 etc...

Date:

05/01/2020

Hour:

14

I have tried Date(Timestamp#(Date_Time,'M-DD-YYYY HH:MM:SS.SSS'),'M/DD/YYYY')

[rwunderlich · Accepted solution]

Date(Floor(Timestamp#(Date_Time,'M-DD-YYYY hh:mm:ss[.fff]')),'M/DD/YYYY')

Hour(Timestamp#(Date_Time,'M-DD-YYYY hh:mm:ss[.fff]'))

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com