Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Jul 2002
    Location
    Houston, TX
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts

    (ASP & MSSQL Server 2000) Matching date for query **Resolved**

    I am trying to pull records based on date... the field is date/time and the data is like:
    2002-08-12 10:21:13.000

    I want to pass it
    08/12/2002

    but it is not returning any records...
    any ideas?
    Michael
    Last edited by msimmons; 08-12-2002 at 07:48 PM.

  • #2
    New Coder
    Join Date
    Jul 2002
    Location
    Houston, TX
    Posts
    84
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I got it. I was doing:
    = '08/12/02'
    when I should have been doing:
    >= '08/12/02'
    because of the time stamp "00:01 08/12/02" is greater than just "08/12/02"

    Michael


  •  

    Posting Permissions

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