Using Dates with SQL, ASP

Results 1 to 2 of 2

Thread: Using Dates with SQL, ASP

  1. #1
    JP Norair Guest

    Default Using Dates with SQL, ASP

    I have something like this (simplified) <BR><BR>&#060;%<BR>thedate = date()<BR>%&#062;<BR><BR>. . . . .**WHERE DateField &#062; &#039;" & thedate & "&#039; . . . . <BR>Unfortunately, this has no effect. In fact, I get something resembling a type mismatch, though when I try using a string (rather than a date), it doesn&#039;t work either. Anyhow, there&#039;s an error reported on the Recordset&#039;s .Open line that only shows when I&#039;m doing this date stuff.<BR><BR>I want only records with dates after the specified date to be displayed.**I&#039;m assuming that I&#039;m doing something wrong.**I bet this solution is cake, so please step in. . . (Dammit Jim, I&#039;m a C programmer, not a database guy) <BR><BR>In addition, if my field in the database has Date-time (which it does), how can I utilize the time setting?<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: Using Dates with SQL, ASP

    Do a search for date on they have good articles that will help explain.

Posting Permissions

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