Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date in Query (2003)

    Hi,

    I have a field call ProcessDate and I would like to build a query to show all the data those >5 days from 'ProcessDate' compare today.

    I don't what should I put in the criteria of the query to get what I want.

    Please help.

    Thanks

    Regards

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

    Re: Date in Query (2003)

    If you want to select records whose ProcessDate is more than 5 days before today, use the following expression in the Criteria line:
    <code>
    <Date()-5
    </code>
    If you want to select records whose ProcessDate is more than 5 days after today, use
    <code>
    >Date()+5
    </code>
    You can simply subtract or add 5 because Access calculates dates with 1 day as unit.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date in Query (2003)

    It works.

    Thanks, Hans.

Posting Permissions

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