Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2012
    Posts
    9

    Unanswered: Between two months back and 10 days into the Future

    Between Date() And DateAdd("m",-2,Date()) And DateAdd("d",10,Date())

    Need a query to show only records that are 60 days old or 10 days in the future. Either VBA of SQL will work.

    The above worked for the 60 days back but when I added the 10 day part it breaks.
    Last edited by Kaw4Life; 04-05-12 at 22:02.

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Would not

    Between DateAdd("m",-2,Date()) And DateAdd("d",10,Date())

    do what you're asking? Or am I misreading your question?

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Apr 2012
    Posts
    9
    That would be it, thank you!

    I am a former Network guy looking to try this programming stuff

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Glad we could help!

    Programming is about as much fun as you can have, with your clothes on! Not that I always do it with my clothes on!

    Welcome to dbF!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

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