Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Mar 2005
    Posts
    27
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Date calculation (Access 2000)

    Hi

    I am trying to age my dates in a query, i.e. I have created a table for action points that need to be completed, so consequently I want to show how long the task has been open / outstanding. I want to be able to deduct the date the item was entered from the current date, without having to store the current date or supply it.

    Any ideas greatfully recieved.

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

    Re: Date calculation (Access 2000)

    Say that the field containing the date the item was entered is named DateEntered. You can add a calculated column to the query. Enter the following in the Field: row in the first empty column:
    <code>
    DaysOpen: Date()-[DateEntered]
    </code>
    DaysOpen will be the title of the calculated column.

  3. #3
    Lounger
    Join Date
    Mar 2005
    Posts
    27
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Date calculation (Access 2000)

    Cheers Hans

    I tried something similar to that with now() which it didn't like, but that works a treat.

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

    Re: Date calculation (Access 2000)

    Date() is the current date, whereas Now() is the current date + time.

Posting Permissions

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