date calculations/validations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to create a validation so that a date will appear exactly 364 days
after a date is put into another field.

ie. Policy End Date and Approval End date fields.

the approval end date = policy end date less 1 day. How is the formula
written please.

Hope someone can help.

Cheers

Chris
 
Chris,

Try DateAdd(), like this. PolicyEnd and ApprovalDate must both be type Date
fields.

PolicyEnd= DateAdd("yyyy",1,ApprovalDate) - 1

This will add a year from the date af approval, and subtract a day. This is
what I understood from your thread, although the way you said it seems
otherwise.

Hope this helps,

Sam
 
Back
Top