Results 1 to 4 of 4
  1. #1
    BED is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    26

    >Date() criteria

    This should be a really easy one.



    Im calculating an end date to a field:

    EndDate: DateAdd("m",tblProgram!Duration,tblEnrollment!Star tDate)

    The output is working perfectly.

    I then want to find all the data that is >Date() and it is not pulling in data with an end date of January 2011.

    Am i doing something incorrectly?

  2. #2
    Rixxe is offline Blessed Bear
    Windows 7 Access 2007
    Join Date
    Sep 2010
    Location
    London (Essex ... yep!)
    Posts
    184
    So you just need a query that states:

    WHERE EndDate between DATE() and '01/01/2011'

    Is my guess (?)

    Edit:

    Think i may have missread, if you said its not pulling in dates after DATE() like 2011 (?)
    Then there must be something else going on....

    Where EndDate > Date() should be fine...

  3. #3
    BED is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    26
    Its pullin in some 2011 and 2012 dates, but missing some of them. I also tried between Date() and 1/1/2090 (Basically anything in the future) and it returned all expired as well as current enrollments.

    Any ideas?

  4. #4
    Rixxe is offline Blessed Bear
    Windows 7 Access 2007
    Join Date
    Sep 2010
    Location
    London (Essex ... yep!)
    Posts
    184
    It really should work...
    Try using 15/12/2010 instead of Date() just to see what happens, I don't think its something to do with formats, but check the fields and data to make sure there isn't something odd going on.
    Also if you could post the full code, it might be useful..

    Good luck

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

Similar Threads

  1. Criteria for date due
    By Desstro in forum Queries
    Replies: 4
    Last Post: 11-30-2010, 12:54 PM
  2. DSUM with date criteria from form
    By krutoigoga in forum Reports
    Replies: 4
    Last Post: 07-28-2010, 01:32 PM
  3. Query Date Criteria
    By svanicek in forum Access
    Replies: 1
    Last Post: 07-09-2010, 11:13 AM
  4. Date/Time Criteria
    By KWarzala in forum Queries
    Replies: 3
    Last Post: 06-04-2010, 07:08 PM
  5. Date Criteria
    By tcollins02 in forum Queries
    Replies: 1
    Last Post: 09-09-2008, 08:27 AM

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