Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    327
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Getting a date diff (Access 2000 )

    Is there a built function to give the date differenece when a user enters a number to go back so many days from today? I want to use that date that I get in a query?

    For example, is they enter a value of 14, how can I get it to give the date 14 days from today?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Getting a date diff (Access 2000 )

    It is not clear to me where you want the user to enter a number.

    But adding or subtracting days to a date is very easy, since a date is stored as a number of days in Access. Today's date is Date(), and 14 days ago is Date()-14. Similarly, 14 days from now is Date()+14.

  3. #3
    3 Star Lounger
    Join Date
    Apr 2003
    Location
    Calgary, Alberta
    Posts
    327
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Getting a date diff (Access 2000 )

    haha, sweet, that is much more simple then I thought it would be.

    Thanks again,

    Shimmer

Posting Permissions

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