How to Fix Access Date Criteria Errors in ODBC Queries
Question details
The user needs to filter ODBC-linked Microsoft Access tables by a rolling 30-day date range without triggering an ODBC date criteria error.
- Product
- Microsoft Access ODBC-linked tables
- Device & OS
- not provided
- Scenario
- A user is building a query in Microsoft Access that pulls from an ODBC-linked table and needs to return records from the previous 30 days through today.
- Observed behavior
- Expressions such as Date()-30 are rejected by the ODBC driver even though literal date criteria work correctly.
Before editing the query, open the relevant ODBC-linked table in Datasheet view and confirm the date column displays as real dates. Run the query once with a literal date criterion to verify the ODBC connection itself is working.
Use DateAdd to Build an Explicit 30-Day Date Range
Use this when an ODBC-linked Access table rejects Date()-30 but accepts literal date criteria.
DateAdd is evaluated by Access before the ODBC driver sees the query, so it sends explicit date values instead of an unsupported Access calculation.
Open Microsoft Access, select the query that uses the ODBC-linked table, and switch to Design View.
In the criteria row under the date field, enter: Between DateAdd("d",-30,Date()) And Date().
Run or save the query. Access evaluates the DateAdd expression locally and passes a clear date range to the ODBC driver.

Verify the Linked Date Field Data Type and ODBC Date Syntax
Use this if the DateAdd expression still fails or if you need to confirm the linked table's date column is compatible with the ODBC driver.
Escape Access ODBC Date Errors with WPS Office Spreadsheets
If Microsoft Access ODBC date criteria errors are slowing you down, WPS Office gives you a free, lightweight way to open, analyze, and report on exported Access data. It offers a familiar ribbon interface and strong Microsoft Excel and CSV format compatibility, so you can move data out of Access and continue working without the query friction.

Frequently Asked Questions
Why does Date()-30 fail in an ODBC-linked Access query?
Access normally evaluates Date()-30 as a date calculation, but some ODBC drivers receive the calculation as an unsupported expression instead of a literal date. Using DateAdd("d",-30,Date()) forces Access to send an explicit date range.
What is the correct Access criteria for the previous 30 days through today?
Use Between DateAdd("d",-30,Date()) And Date() in the criteria row of the date field in query Design view.
Does WPS Office include Microsoft Access or fix Access ODBC query errors?
No, WPS Office does not include Access, so it cannot repair Microsoft Access ODBC query errors. However, WPS Spreadsheets can open exported Access data in Excel or CSV format and offers free spreadsheet tools for daily data work.
Can I use WPS Office to work with data exported from Microsoft Access?
Yes. Export your Access table or query to Excel or CSV, then open it in WPS Spreadsheets. You can filter, analyze, and report using a familiar Office-style interface while keeping Microsoft Excel XLSX compatibility.
What date formula can I use in WPS Spreadsheets instead of Access Date()-30?
In WPS Spreadsheets, use =TODAY()-30 to calculate the date 30 days ago. You can combine that with filters or helper columns when working with exported Access data.




