search for a date in a database

Results 1 to 5 of 5

Thread: search for a date in a database

  1. #1
    Join Date
    Dec 1969
    Posts
    116

    Default search for a date in a database

    I&#039m trying to do an SQL query that searches for a date in an Access database. I have no problems doing a text search.I&#039m doing this from a .asp page

  2. #2
    Jairo Guest

    Default RE: search for a date in a database

    Tanya,<BR>Show us your source code for what you&#039re trying to do.<BR>Then I can give it a shot.<BR>HTH,<BR>Jairo<BR>http://www.citywebarchitects.com

  3. #3
    Join Date
    Dec 1969
    Posts
    116

    Default RE: search for a date in a database

    This is my SQL statement<BR><BR>select * from learner where 1=1 AND courseDate =Jan/1/1999 <BR>

  4. #4
    Jairo Guest

    Default RE: search for a date in a database

    Tanya,<BR>For MS-Access, you can specify dates by enclosing it in #.<BR>select * from learner where 1=1 AND courseDate #1/1/1999#<BR><BR>HTH,<BR>Jairo<BR>http://www.citywebarchitects.com <BR><BR>


  5. #5
    Join Date
    Dec 1969
    Posts
    116

    Default RE: search for a date in a database

    Thanks<BR>That works great....much easier than the other solution I found

Posting Permissions

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