View Single Post
  #1   Report Post  
Kane
 
Posts: n/a
Default Age & Time Restricted Validation dates ...

Birthdate in A43
Issue Date in G37
New Valid to Date ( ? ) in K37

Restrictions a
Age<40=12 months (to the 1st day of the following month)
Age40=6 months (to the 1st day of the following month)
Revalidation grace period=90 days prior to Valid to Date=normal Valid to Date
Revalidation prior to 90 day grace period=new Age <40 or Age40
Beyond Valid to date="Expired"

How would I set this up? There is a continuation to this, but thought we
could start from here.
Happy New Year , & in Rememberance!

.... Wayne