Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    May 2003
    Location
    Kansas City, Kansas, USA
    Posts
    76
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hello all, I am having problems with dates again.... They trip me up eveytime Anyway, I have a query that I need to show all records that are 10 years or older from their effective date. I know this is easy but my brain is not working.....

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Do you mean that the EffectiveDate field in the Table is over 10 years from Today?

    If so the Criteria ought to be something like

    [EffectiveDate] < DateAdd("yyyy",-10,Date())
    Andrew

  3. #3
    Star Lounger
    Join Date
    May 2003
    Location
    Kansas City, Kansas, USA
    Posts
    76
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Ok sorry, yes thank you!

Posting Permissions

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