Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Posts
    1

    Exclamation Unanswered: Comparing two date

    Any one here can help me on comparing two date in microsoft access?

    eg.

    [expDate] >= [CurrentDate]


    I would like to know how the ways to compare two dates using operator or another way of it?

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    you might have to give a touch more detail to get a meaningful answer, but given a field ThisIsMyDate which is correctly managed, the expression:
    [ThisIsMyDate] < Now() {or"=" or">" or"<>" etc}
    should evaluate correctly.

    izy

  3. #3
    Join Date
    Oct 2002
    Posts
    48

    DateValue(ExpDate) < DateValue(Date())

    Use :

    DateValue(ExpDate) < DateValue(Date()).


    Date() will have only Date
    Now() will have date and curretn time also.

Posting Permissions

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