Results 1 to 2 of 2
  1. #1
    Join Date
    May 2015

    Unanswered: Question about Dates

    Is it possible to have access get the current system date and after it has the current system date to add 10 days to that date? If so how would you go about doing something like that. What I am asking is a little out of my VBA programming skills at this time. Thanks for any help you can give.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    The current system date can be retrieved using one of two function calls
    date () returns the current date of the computer
    now () returns the current date and time of the computer
    bear in mind that its the date (and time) of the computer which is running the code not a single central source, as you would in a clent server db. This can be an issue if your networked computers are not regularly synchronising time or if you have computers on a network with different time zone setings

    To add n days to a date use the dateadd function. Access comes with a fairly comprehensive range if functions for manipulating temporal data.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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