ExcelBanter - MS Query question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - MS Query question (https://www.excelbanter.com/excel-worksheet-functions/128889-ms-query-question.html)

shmurphing

MS Query question

I am pulling data via OBDC and would like to use MS Query to use criteria for
a date/time field that is not a date/time.

For clarity, instead of the criteria being Reported Date/Time <Jan 31, 2007
00:00:00, I want it to state Reported Date/time <*24 hours from now

Possible?

All times are GMT +1. The time now is 09:00 AM.