Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a variable that displays 'YYYYMMDD hh:mm', but I only need the hours so that I can display it in a chart axis. I've tried 'time(Timestamp#(fieldname,'YYYYMMDD hh:mm'),'hh:00') as newVarName' but I got
How can I group them into only 1 of each hour? Thanks.
Try with hour(), like:
hour(Timestamp#(fieldname,'YYYYMMDD hh:mm')) as newVarName
Hi
Try
hour(fieldname) as Hour
Regards
ASHFAQ
Try this
Interval(Timestamp#(fieldname,'YYYYMMDD hh:mm'),'hh') as Hour
Try to apply:
=Hour(Timestamp(colomn name,'hh'))