Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Posts
    150

    Unanswered: Need a formula to find dates after 2014

    Hello,

    I need to run a query to find out if any dates have been scheduled past 12/31/2014. I was trying to using this formula Year(Date())+1 in my query, but it is not working. Of course, I am doing something wrong. Maybe someone has a better formula or the correct one.

    I am using Microsoft Access 2010.

    Thank you so much.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    where mydatecolumn > #2014/12/31# 'assumign you are not storing any time value
    where mydatecolumn >= #2015/01/01# ' assuming you are storing time values
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Sep 2008
    Posts
    150
    You are the BEST healdem!

    Thank you soooo much!

Posting Permissions

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