topic Retrieve Hour value from Date Field in QlikView

Retrieve Hour value from Date Field

Fri, 04 Mar 2011 02:40:51 GMT

I have a field that contains a date in the following format: 24/12/2002 12:31:00 AM

I need to be able to determine the hour that this occurred in.

Thanks in advance.

Anonymous — Fri, 04 Mar 2011 04:35:05 GMT

Here's a solution that takes into consideration a value like 5pm and returns 17 instead of 5, which would easily be mixed up with 5am:

=interval(frac(timestamp(timestamp#('24/12/2002 5:31:00 PM', 'DD/MM/YYYY hh:mm:ss TT'),'DD/MM/YYYY hh:mm:ss')), 'hh')

Fri, 04 Mar 2011 05:01:52 GMT

Thanks works a treat.