Find Education Plans Older Than Six Months in Microsoft Access
Question details
The user needs an Access query that finds students whose education-plan dates are earlier than six months before today.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Filter student records by the Date of Ed Plan field to identify plans older than six months.
- Observed behavior
- Adding six months to each education-plan date did not produce the required comparison. Comparing the field with a cutoff six months before today returned the expected records.
Identify the actual education-plan date field and confirm that its data type is Date/Time rather than text. If you need plans that expired more than six months ago, use the expiration-date field rather than the plan creation date.
Filter the education-plan date using a six-month cutoff
Use this criterion to return records whose date is strictly earlier than six calendar months before today.
DateAdd("m", -6, Date()) calculates the cutoff by subtracting six calendar months from today's date. The less-than operator compares each record's date with that cutoff.
In the Access Navigation Pane, right-click the query and select Design View. To create a new query, select Create > Query Design and add the table containing the student records.
Double-click the Date of Ed Plan field, or the actual date field used in your database, to add it to the query design grid. Add any student identification fields you want displayed.
In the Criteria row under the education-plan date field, enter: <DateAdd("m", -6, Date()). Apply the criterion to the field itself; do not compare a record date with that same date plus six months.
On the Query Design tab, click Run, marked with an exclamation point. Check that the returned plan dates are earlier than the six-month cutoff, then save the query.

Review Exported Education-Plan Records in WPS Spreadsheet
WPS Office is a free, lightweight, easy-to-use Office alternative with a familiar interface and Excel format compatibility for a smooth transition to spreadsheet reporting. Export your Access query results to an Excel file to review them in WPS Spreadsheet. WPS does not run Access queries or replace the Access database engine.

Frequently Asked Questions
Where do I enter the six-month criterion in Access?
Open the query in Design View and enter <DateAdd("m", -6, Date()) in the Criteria row beneath the education-plan date field. Click Run to display matching records.
Does this include plans dated exactly six months ago?
No. The < operator excludes dates equal to the cutoff. To include the cutoff date, use <=DateAdd("m", -6, Date()). If the field also stores times, the cutoff is midnight at the start of that date.
Is six months the same as 180 days in this query?
No. DateAdd("m", -6, Date()) subtracts six calendar months. If your policy specifies 180 days instead, enter <DateAdd("d", -180, Date()) in the date field's Criteria row.
Why aren't records with blank plan dates returned?
Blank Date/Time values are Null and do not satisfy a less-than comparison. To include missing dates, enter Is Null in the Or row beneath the same date field, leaving the six-month criterion in the Criteria row.
Can WPS Spreadsheet run this Access query?
No. Run the query in Microsoft Access, then select External Data > Excel to export its results. Open the exported .xlsx or .xls file in WPS Spreadsheet for review, filtering, or reporting.




