var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Answered: Due Date Calculation
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?
Table Field - Inspection Date: 12 May 15
Table Field - Time Remaining: 15
Thank you in advance
"Nevermind i Figured it out, should have been 4 yyyy instead of 1. Thank for your help. "
Have a look at the DateAdd() and DateDiff() functions in Access help.
Have a nice day!
Thanks, I checked it out and gave it ago 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??
Nevermind i Figured it out, should have been 4 yyyy instead of 1. Thank for your help.