How to Fix Date Syntax Errors in Microsoft Access Query Expressions
Question details
The user needs to resolve date syntax errors in Microsoft Access query expressions and determine the correct way to store, display, and query the FD_Date field.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- The user maintains an Access form with an unbound combo box set to Now() on load and appends daily dates to a Food_Distribution table using the regional DD.MM.YYYY format.
- Observed behavior
- Access returns date syntax errors or produces incorrect criteria results when FD_Date is stored as text or queried using regional date text values.
Open the Access database, open the Food_Distribution table in Design View, and confirm whether FD_Date uses the Date/Time data type or Text. Also check the Windows regional date format so you can match query criteria and display formats intentionally.
Store FD_Date as a Date/Time Field and Remove Text Delimiters from Date Criteria
Use this solution when your query criteria treat dates as text or when the FD_Date field is currently stored as Text, because the Date/Time type prevents most regional date syntax errors and keeps sorting reliable.
Access evaluates Date/Time fields by their underlying numeric value. The regional date format is only a display format, so you can keep DD.MM.YYYY on screen without storing the date as text.
In the Access Navigation Pane, right-click the Food_Distribution table and select Design View.
Click the Data Type column for FD_Date, choose Date/Time, and save the table. If Access prompts to convert existing text, first correct any invalid date text in the table.
In Query Design View, click the Criteria row under FD_Date and use the query date picker or type an Access date literal that matches your Access locale, such as #2/1/2025# for U.S. settings. Avoid quoted text like '01.02.2025'.
Click Run on the Query Tools Design tab and confirm the records appear in chronological order rather than alphabetical order.

Keep the Regional Date Format for Display Only and Adjust the Form Combo Box
Use this solution when other applications depend on the DD.MM.YYYY display but you still need Access to sort and query dates correctly.
Move Access Data Tasks to WPS Office for Everyday Spreadsheets and Reports
WPS Office is not an Access database replacement, but it is a free and lightweight Office alternative that helps you work with exported Access data, documents, and reports in a familiar ribbon interface with high compatibility for Microsoft Excel, Word, and PowerPoint files.
- 1. Export Access data to Excel: In Microsoft Access, select the table or query, click External Data, and choose Export to Excel to create an .xlsx file.
- 2. Open the exported file in WPS Spreadsheets: Launch WPS Office, click Menu > Open, and select the exported .xlsx workbook to review or summarize the data.
- 3. Create or edit related documents: Open Word-compatible reports or PowerPoint presentations in WPS Writer or WPS Presentation and continue using the familiar ribbon tools.
- 4. Save in Microsoft-compatible formats: Use Menu > Save As to keep .xlsx, .docx, or .pptx formats for teammates who still use Microsoft Office.

Frequently Asked Questions
Why does Access show a date syntax error when I enter DD.MM.YYYY in query criteria?
Access treats DD.MM.YYYY as text unless the field is Date/Time and the literal is correctly delimited. Store the field as Date/Time, then use the query date picker or an Access date literal appropriate for your Access locale. Avoid plain quoted text like '01.02.2025'.
Should I store FD_Date as text to keep the DD.MM.YYYY format?
No. Store FD_Date as a Date/Time field. Set the control Format property to dd.mm.yyyy for display, and use the Windows regional format for any other application. Text dates cause string sorting and criteria errors.
How do I stop an unbound combo box from automatically setting Now() when the form opens?
Open the form in Design View, select the combo box, open the Property Sheet, and check the Form Load event. Remove or change the line that assigns Now() to the unbound combo box unless it is bound to a Date/Time field and you truly need a default value.
Can WPS Office open .accdb or .mdb Access database files?
No, WPS Office is an alternative for spreadsheets, documents, and presentations. Export the Access query or table to an Excel .xlsx file, then open it in WPS Spreadsheets. You still need Microsoft Access for the database application and its query engine.




