Due Date Calculation

[DFeil]

Hello,

What would the criteria be in a query to create a formula that will calculate the due date based off of an inspection date plus a time remaining field in years?

Example:

Table Field - Inspection Date: 12 May 15
Table Field - Time Remaining: 15 in Years

Thank you in advance

Dave

[June7]

Explore the DateAdd() function.

The TimeRemaining field should be a number type and contain only a number, not text "15 in Years"


Advise no spaces or special characters/punctuation (underscore is exception) in naming convention.

[DFeil]

Thanks, Time Remaining is in number only, I just put "in Years" to show you it was in years. I checked it out and gave it a go and came up with this;
Expr1: DateAdd("y",[RVTimeRemaining],[InspectionDate]) it is calculating but it is calculating the days not years. Where did I go wrong??

Dave

[DFeil]

Nevermind i Figured it out, should have been 4 yyyy instead of 1. Thank for your help.