Results 1 to 2 of 2
  1. #1
    thart21 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    83

    Query criteria, add 5 months to date

    Could someone point me to a thread or a search keyword for this?
    I have a date field "Buy Date" in my query. I want to pull all of the records that are from the current month + 5 months.

    Current Month Buy Date
    March 08/01/2010
    April 09/01/2010

    I've tried several "Date" functions but nothing seems to work.



    Thanks

  2. #2
    thart21 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    83
    Found this on another site. Thanks

    Year([DLVR_MONTH_DT])*12+DatePart("m",[DLVR_MONTH_DT])=Year(Date())*12+DatePart("m",Date())+5

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

Similar Threads

  1. Total all months in query or report
    By Brian62 in forum Queries
    Replies: 2
    Last Post: 10-23-2009, 08:41 AM
  2. Replies: 0
    Last Post: 02-27-2009, 01:39 PM
  3. Setting criteria in a calculated date field
    By SteveReberger in forum Access
    Replies: 0
    Last Post: 10-29-2008, 06:58 AM
  4. Date Criteria
    By tcollins02 in forum Queries
    Replies: 1
    Last Post: 09-09-2008, 08:27 AM
  5. A months query
    By Peljo in forum Access
    Replies: 1
    Last Post: 02-18-2008, 09:07 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