Results 1 to 3 of 3
  1. #1
    Lorlai is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jun 2011
    Posts
    107

    Criteria: >=Todaysdate()

    I have a criteria that I want to include in my query. I have a field with end dates, and I would like to pull all the dates that end after today's date. When I try to incorporate this into the criteria, I get an error that says "today" is an undefined function:



    Criteria: >=today()

    I feel that there must be a simple way to do this, does anyone know how?

    Thank you!

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    >=Date()

    is what you want.

  3. #3
    Lorlai is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jun 2011
    Posts
    107
    Thank you, I knew it had to be something that easy

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

Similar Threads

  1. criteria
    By kwooten in forum Queries
    Replies: 47
    Last Post: 08-03-2011, 09:12 AM
  2. Replies: 1
    Last Post: 07-13-2011, 11:00 AM
  3. Replies: 1
    Last Post: 06-12-2011, 07:08 AM
  4. Criteria help
    By jcaptchaos2 in forum Access
    Replies: 13
    Last Post: 05-08-2011, 06:49 PM
  5. Search By Criteria - Flexible Criteria Fields
    By lilanngel in forum Access
    Replies: 0
    Last Post: 03-16-2011, 06:25 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