Extracting Last 24 Hours Data

Question

Hello Everyone-

I have a data which has date and time scans when a sales-order is scanned complete (please find in attached the sample data). what i am trying to achieve here is pull those sales-order which were scanned in last 24 hours form the time when the report is executed. Meaning if the report is scheduled to come out at 8am on 8/16/18 then is should have all the scanned Sales-order from 8am 8/15/18 through 7:59 am 5/16/18.

I tried [Scan_DteTime]=DateTimeAdd([Timenow],-24,'hours') and it didn't worked .

Will really appreciate any guidance.

Thank you .

test_data1.xlsx

patrick_digan · Accepted Answer

@MD2050 try switching your equal sign to a >= sign, like:

[Scan_DteTime]>=DateTimeAdd([Timenow],-24,'hours')

patrick_digan · Accepted Answer

@MD2050 I've attached an example. You'll just want to save it to the same directory as that sample excel file you posted. The left side uses DateTimeNow(), The middle uses the timestamp from the excel file, and the right side is if you wanted to hardcode it. Then I just compare the time to the start and end time variables that we've created.