Results 1 to 3 of 3
  1. 09-25-2007, 11:45 AM #1
    cpsummer
    cpsummer is offline Novice
    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
    Reply With Quote Reply With Quote
  2. 09-25-2007, 03:19 PM #2
    jya
    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
    Reply With Quote Reply With Quote
  3. 09-26-2007, 02:31 PM #3
    cpsummer
    cpsummer is offline Novice
    Join Date
    Sep 2007
    Posts
    2
    It works fine.... Good enough for me.
    Thank you very much!!
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Query (Date Question)
    By cillajones in forum Queries
    Replies: 1
    Last Post: 08-09-2008, 12:05 PM
  2. Query field to get 1 years worth of totals - show total...
    By srlincoln in forum Queries
    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. Make sure end date is one year greater than start date
    By AimeeK in forum Forms
    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
  •  

Forum Rules

Other Forums: Microsoft Office Forums