Results 1 to 3 of 3
  1. #1
    techexpressinc's Avatar
    techexpressinc is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151

    Date Calculation ?

    I have a date and a number of days in the future from the date.

    I need to display what that date will be:

    i.e.
    I have the Start-Date 05-29-09

    I need to show the completion date:
    i.e.
    + 90 days = 08-27-09

    I know the +90 but not the 08-27-09.

    How can I do this in Access?



    Thank you
    Russ

  2. #2
    techexpressinc's Avatar
    techexpressinc is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151
    Found it a function = Expr1: DateAdd("d",90,[DateofConsent])

  3. #3
    marianne is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Asia Pacific Region
    Posts
    150
    glad you found your answer. thanks sharing your answer and for posting back your success.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Calculation Help
    By edge5511 in forum Programming
    Replies: 4
    Last Post: 12-18-2015, 11:11 AM
  2. Date Calculation -- HELP!
    By klaauser in forum Forms
    Replies: 0
    Last Post: 12-22-2008, 02:14 PM
  3. Question about creating a date calculation tool
    By bazillion in forum Programming
    Replies: 0
    Last Post: 01-25-2008, 12:08 PM
  4. Calculation
    By thestclair in forum Reports
    Replies: 1
    Last Post: 04-29-2006, 11:03 AM
  5. Date Calculation within same fields
    By mslieder in forum Queries
    Replies: 3
    Last Post: 01-26-2006, 10:08 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums