Skip to Content
0
Former Member
Jun 18, 2009 at 01:29 PM

Data for current hour

29 Views

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