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

    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
    Location
    Chicagoland
    Posts
    109

    quick and dirty answer

    Hmm...

    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
    Posts
    2
    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