query on date()

Results 1 to 2 of 2

Thread: query on date()

  1. #1
    Join Date
    Dec 1969

    Default query on date()

    My linktracker script queries a recordset to check to see if it is the first hit of the day.<BR>The hitdate field was updated using set hitdate= date()<BR>then when queried it comes up .eof no record ?<BR>Do i have to do anything special when querieng a date ?

  2. #2
    Join Date
    Dec 1969

    Default RE: query on date()

    Perhaps check out the following:<BR><BR>Could I get a little help with dates? - 8/15/2000<BR>http://www.aspfaq.com/faq/faqShow.asp?fid=52<BR>"If you are using Access, you need to surround dates with pound signs (#). With most other databases, including SQL Server 7, dates are surrounded with apostrophes (&#039;) and are treated like strings. Make sure your date is a valid date. You can do this in VBScript using the isDate() function."<BR><BR>Best regards,<BR>-Paul<BR><BR>Bullschmidt.com - Databases on the Web<BR>http://www.Bullschmidt.com

Posting Permissions

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