VBA date calc using If..Then..Else

• • Reply

  19 years ago

  by BigDaddyCool

  Jason Yunnie

  London, United Kingdom

  Joined 19 years ago

  Hey, I'm using a numeric flagging system in a database I have developed, for use in insurance industry, basically for taking on General Insurance Standards Council appointed agents.
  

  
  e.g. Data capture person is plugging data from paper application form into database, and specific answers are automatically flagged between 1 and 5, 1 being good 5 being bad, for an overall risk rating.
  

  
  However, one question poses a problem, as am unsure how to achieve end goal.
  

  
  Question is, "When was your business established", and if the response (in short date format) is less than 12 months before present date, then I want to flag as a 3 out of 5, i.e. moderate risk. Can anyone help with specific code or anything else, have been trying to use If..Then..Else statement on AfterUpdate in VBA, but no luck

  Report abuse
• • Reply

  19 years ago

  by gigsvoo

  gigsv00

  , United States

  Joined 19 years ago

  Use DateDiff() function to get the days, months or years between two dates

  Report abuse