Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Between 2 dates in a query (Access97)

    I know you can have a query select data between date 1 and date 2. But what can I do if I want to select records older than 2 weeks but not older than 4 weeks? And I don't want to make the user type in the dates.. Any thoughts? Thanks.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Between 2 dates in a query (Access97)

    Hi Gary,
    Try something like
    Between Date()-28 And Date()-14
    You may want to adjust this depending on exactly which dates you want to include.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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