Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2012
    Posts
    20
    Provided Answers: 3

    Answered: Due Date Calculation

    Hello,

    What would the criteria be in a query to create a formula that will calculate the due date based off of an inspection date plus a time remaining field in years?

    Example:

    Table Field - Inspection Date: 12 May 15
    Table Field - Time Remaining: 15

    Thank you in advance

    Dave

  2. Best Answer
    Posted by DFeil

    "Nevermind i Figured it out, should have been 4 yyyy instead of 1. Thank for your help. "


  3. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Have a look at the DateAdd() and DateDiff() functions in Access help.
    Have a nice day!

  4. #3
    Join Date
    Oct 2012
    Posts
    20
    Provided Answers: 3
    Thanks, I checked it out and gave it ago and came up with this;

    Expr1: DateAdd("y",[RVTimeRemaining],[InspectionDate]) it is calculating but it is calculating the days not years. Where did I go wrong??

    Dave

  5. #4
    Join Date
    Oct 2012
    Posts
    20
    Provided Answers: 3
    Nevermind i Figured it out, should have been 4 yyyy instead of 1. Thank for your help.

Posting Permissions

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