Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    India
    Posts
    4

    Unanswered: compare two dates

    Hi,
    I am working on it from last two days...
    I want all the records between two dates...
    This query is running in the Oracle...but not in the MS Access2000...
    SELECT....
    FROM...
    WHERE date between '02-02-03' AND '03-03-03'

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    WHERE date between #02-02-03# AND #03-03-03# should do it.

    izy

Posting Permissions

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