Data for current hour

[Former Member]

Hello,

I am trying to use a query to get data from our database for the current hour.

I am using the below for an existing report for previous hour.

{TTID_129L3597.Rn_Create_Date} in dateadd("h",-1,dateadd("n",-minute(currentdatetime),dateadd("s",-second(currentdatetime),currentdatetime))) to

dateadd("n",-minute(currentdatetime),dateadd("s",-second(currentdatetime),currentdatetime))

Is there any simpler formulas that can be used to get data created during the current hour?

Thanks,

Joe

[Former Member · Accepted solution]

The logic would be the same but if you are looking to fetch data for the current hour then try this:

date({TTID_129L3597.Rn_Create_Date}) = currentdate and
time({TTID_129L3597.Rn_Create_Date}) in 
time(hour(currenttime),0,0) to time(hour(currenttime),59,59);

Edited by: Sanjay Kodidine on Jun 18, 2009 7:14 AM