Date field comparison

Results 1 to 2 of 2

Thread: Date field comparison

  1. #1
    Swanand Guest

    Default Date field comparison

    I have a column in the database which has the date and time in eg .9/12/99 3:00:00pm format.<BR>How can I compare it with a date entered by an user ona textfield? eg. 9/12/1999?<BR><BR>select * from tblName where dateInTable &#062; request.form("userEnteredDate") ?????<BR><BR>Please help

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: Date field comparison

    Dim strSQL<BR>strSQL = "select * from tblName where dateInTable &#062; &#039" & request.form("userEnteredDate") & "&#039"<BR><BR>Dim objRS<BR>Set objRS = objConn.Execute(strSQL)<BR><BR>Read:<BR>To Quote or Not to Quote - That is the Question<BR>http://www.4guysfromrolla.com/webtech/013099-1.shtml<BR><BR>

Posting Permissions

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