I would think that you would want a new record for each time you inspect a vehicle. One table for the vehicles linked to a table of inspection records. That allows you to have a new due date for each inspection and when an inspection has been made, a new inspection record would be made for the next annual inspection.
Thanks for the quick response... Seeing as the dates are the same every year I was hoping to avoid starting another table just for that. It's more of a flag than a record. We know they are being done, it's just a matter of giving the shop foreman the heads up of how many vehicle he may have for safety in any given month, allowing them to pull them off the road and change out the drivers. Thus if possible I would like to take care of it in formula(s)
But the dates aren't the same every year. The year changes each time. And if that value isn't changed, you can't readily compute your date count down.
And is there a field that records when or if the inspection was performed?
If ( DueDate > Get ( CurrentDate ) ; DueDate - Get ( CurrentDate ) )
Will keep from computing negative numbers and when you change the year value, the calc will reappear showing days to the next inspection date.