How to Calculate Renewal Dates with DateAdd in Microsoft Access
Question details
The user needs to calculate a valid-through date and a renewal date in Microsoft Access by adding a term length in years to an effective date with the DateAdd function.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- The user has an effective date and a term length in years, and wants to compute an expiration date and a renewal date one month before expiration.
- Observed behavior
- The expected result is a valid expiration date and a renewal date calculated from numeric term years and a valid Date/Time effective date field.
Before you start, confirm that the field holding the term length is numeric and the effective date field uses the Date/Time data type in your Access table or query.
Calculate the Valid-Through Date with DateAdd("yyyy", [Term Yrs], [Effective Date])
Use this expression when you need to add the full term years to an effective date to get an expiration or valid-through date.
The interval "yyyy" tells DateAdd to add years. Access returns a Date/Time value, so format the calculated column as a date if it does not display correctly.
In Microsoft Access, open the database and open the target query in Design View.
Click in the Field row of a blank column and enter: ValidThrough: DateAdd("yyyy", [Term Yrs], [Effective Date]).
On the Design tab, click Run to display the calculated valid-through dates.
Calculate a Renewal Date One Month Before Expiration with DateAdd("m", [Term Yrs] * 12 - 1, [Effective Date])
Use this expression when the renewal date must be one month earlier than the expiration date, calculated from the same effective date and term length.
Use WPS Office as a Free Alternative for Microsoft Office Document Workflows
The DateAdd calculation is a Microsoft Access feature, and WPS Office does not include an Access database engine. For everyday Office work, WPS Office is a free, lightweight suite that opens and saves Microsoft Word, Excel, and PowerPoint formats with a familiar ribbon interface, making migration easy.
- 1. Download WPS Office: Download WPS Office from the official WPS website.
- 2. Install and launch: Install WPS Office, then open Writer, Spreadsheets, or Presentation depending on the file you need to edit.
- 3. Open existing Office files: Open Microsoft Office files and continue editing them in their original formats.

Frequently Asked Questions
What does DateAdd("yyyy", [Term Yrs], [Effective Date]) do in Access?
It adds the number of years stored in the Term Yrs field to the Effective Date field and returns the resulting expiration or valid-through date.
How do I calculate a renewal date one month before expiration?
Use the expression DateAdd("m", [Term Yrs] * 12 - 1, [Effective Date]). This converts years to months and subtracts one month so the result falls one month before the full expiration date.
Why does my DateAdd expression return #Error?
Check that the term field is numeric, the effective date field is a valid Date/Time field, and the field names in brackets match the query or table exactly.
Can WPS Office run Microsoft Access databases?
No, WPS Office does not include an Access-compatible database engine. WPS Writer, Spreadsheets, and Presentation provide free alternatives for documents, spreadsheets, and presentations.
Do I need quotation marks around the interval in Access DateAdd?
Yes, the interval argument must be a string. Use "yyyy" for years or "m" for months.


![Calculate a Renewal Date One Month Before Expiration with DateAdd("m", [Term Yrs] * 12 - 1, [Effective Date])](https://res-academy.cache.wpscdn.com/upload/seo-engine-admin/2026-11-13/2e7cb1ead27bc4b3a347869d459b7aa1.png)


