Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2007

    query date that is five years older than today

    Can you please help me in how to extract the data that has a member sign in date older than five years from today's date. Thank you

  2. #2
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007

    quick and dirty answer


    How exact do you need to be? :roll:

    Expr1: DateDiff("d",[member_date],Now())

    with a criteria of >5* 365

  3. #3
    Join Date
    Sep 2007
    It works fine.... Good enough for me.
    Thank you very much!!

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

Similar Threads

  1. Query (Date Question)
    By cillajones in forum Queries
    Replies: 1
    Last Post: 08-09-2008, 12:05 PM
  2. Replies: 1
    Last Post: 03-15-2007, 03:38 PM
  3. Need to set date in query for automation
    By Valeda in forum Queries
    Replies: 0
    Last Post: 06-07-2006, 06:41 AM
  4. Replies: 1
    Last Post: 12-09-2005, 10:29 PM

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