Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
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
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