Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2004
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    NOW minus 3 months (2003 SP2)

    I would like to create a Report that only includes criteria if it falls within the last 3 months.

    I've looked up Access' Help, and I can see how--using: DateSerial(Year([StartDate]),Month([StartDate])-3,Day([StartDate]))--I can get Access to calculate back 3 months. But what I need is Access to look at today's date and then only include records that occured within the last 3 months. So, my criteria would be BETWEEN NOW() AND NOW() minus 3 months.

    I'm sure this is possible, but after spending more than an Hour using Access' Help & Microsoft Office Assistance, I can't find the proper way to 'write' this.

    Any help is greatly appreciated.

    Thanks in advance.

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

    Re: NOW minus 3 months (2003 SP2)

    Try

    Between DateAdd("m", -3, Date()) And Date()

    Note: I used Date() instead of Now(). Now includes a time component; you don't need that here since you're only interested in the date.

  3. #3
    Star Lounger
    Join Date
    Mar 2004
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: NOW minus 3 months (2003 SP2)

    Thanks Hans

    Easy when you know how, huh?

    Greatly appreciate your help. [img]/forums/images/smilies/smile.gif[/img]

    Have a great day!

Posting Permissions

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