Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    56

    Unanswered: Simple Date formula, not for me:(

    Hi all, I have what should be a simple date formula but I am unable to get the results I am trying to get.

    I have a date field (which indicates contracts dates) and I need to single out all dates < 05/31/03 and >05/30/03.

    Could someone help me with that formula please. I am using Access 2003.

    Thank you ahead of time.

  2. #2
    Join Date
    Jun 2004
    Posts
    55
    Use <= #date# and >= #date#.

  3. #3
    Join Date
    Mar 2004
    Posts
    56
    And here I was trying to get datediff to work I KNEW it should have been simple, thanks so much you saved my behind!

  4. #4
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    Quote Originally Posted by roma92
    Hi all, I have what should be a simple date formula but I am unable to get the results I am trying to get.

    I have a date field (which indicates contracts dates) and I need to single out all dates < 05/31/03 and >05/30/03.

    Could someone help me with that formula please. I am using Access 2003.

    Thank you ahead of time.
    Note that this query will return NOTHING ...

    Regards

Posting Permissions

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