Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Oct 2001
    Location
    New York
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Calculations (97 SR1)

    I've created a form, which has [DateReviewed] as a date field. Next to it, I'd like to have a field "Next Review Date" which would automatically calculates a date 3 years from [DateReviewed]. So as soon as the [DateReviewed] is changed, the "Next Review Date" would automatically recalculate.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Date Calculations (97 SR1)

    The DATEADD function in Access will do exactly what you want - search for help on dates to find info about it. The next question is are you planning to store it in a table or something? If so why? You can always recalculate it on the fly, and then when the [DateReviewed] is changed, it will also change. You can even run a query and find ones where the "Next ReviewDate" is approaching. Good luck.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •