MS Query show records that are not updated for 15 days or greater

[v8chevy68]

Hi All

I have an ODBC datasource which I need to use with MS Query

There is a field called 'modified date' which contains 1000's of records.

I need to make the query return only records that are 15 days or greater since last modified

The 'modified date' field cannot be changed as it is on an external system.
The field also includes a time-stamp

example: 2018-02-27 14:15:53.000

Please can anybody advise me how i can accomplish this?
Many thanks

 

[mole999]

can you post your actual query here (without user or password identified)

 

[v8chevy68]

Hi There
i cant post the query,
i have tried the following syntax but it fails

=> today()-15
Thanks again for any suggestions

 

[John_w]

Record a macro of you doing the MS Query, including the Filter Data step where you choose 'modified date' less than or equal to an arbitary date. The generated code will show you the correct syntax for the WHERE part, which you can edit and change to use the Format and Date functions, something like this:

"WHERE (`Sheet1$`.`modified date`<={ts '" & Format(Date - 15, "YYYY-MM-DD") & " 00:00:00'})"