Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2005
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    qryPastDue (2000)

    Hey guyse
    I want to create a query that gives me all that records where the date field is 3 months old. I can't figure out the exspression. Is it EDATE? Thanks in advance, you guys always come through for me!

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: qryPastDue (2000)

    What is EDATE? Your query would be something like this:

    SELECT * FROM MyTable WHERE MyDate < Date() - 90

    That's assuming your table is named MyTable, with a date field named MyDate and you want to see all records with a date earlier than today - 90 days. If that isn't what you meant, you'll have to explain further.
    Charlotte

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

    Re: qryPastDue (2000)

    EDATE is an Excel worksheet function; it is not available in Access. Charlotte has already posted a solution; another one is

    SELECT * FROM MyTable WHERE MyDate < DateAdd("m", -3, Date())

Posting Permissions

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