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