Results 1 to 2 of 2
  1. #1
    Xterra14s is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    May 2016
    Posts
    32

    Pulling a query for specified date range

    Hello everyone,
    So what I am trying to do is pull a query where all results come based on a referral date. I only want to see referrals that do not have a DOS that were generated 60 days from today going back. So the referral date would have to be 60 days in the past from the current date. The effective date that this policy starts is 02/06/2017 so that is where that date comes from.


    This is what I have but it is not pulling the right information and I can't figure out why:
    <Date()-60 And >#2/6/2017#

    Thank you all!

  2. #2
    AccessPower's Avatar
    AccessPower is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    165
    WHERE DOS < DATEADD("d", -30, DATE())

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 01-26-2016, 01:56 PM
  2. Problems with date range in query
    By pbaccess in forum Access
    Replies: 1
    Last Post: 02-18-2014, 04:54 AM
  3. Query for date range
    By BRZ-Ryan in forum Queries
    Replies: 23
    Last Post: 02-05-2014, 09:08 PM
  4. Date Range Query
    By need_help12 in forum Queries
    Replies: 7
    Last Post: 04-25-2012, 01:38 PM
  5. Run query by date range
    By ARickert in forum Access
    Replies: 2
    Last Post: 06-23-2011, 10:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums