Hi all,
I have a datetime data field in SQLServer7, and I am trying to get a recordset
according to criteria that the CallDate field in the database equals todays date
09/12/2002
Dim TodaysDate
TodaysDate= cDate(Date)
sCallsSQL = "SELECT
CallBacks.CallDate,CallBacks.CallTime,LearnerDetails.LearnerID,CallBacks.LearnerID,
LearnerDetails.FName,LearnerDetails.LName,LearnerDetails.TelPref,LearnerDetails.TelMobile
From CallBacks,LearnerDetails WHERE LearnerDetails.LearnerID = CallBacks.LearnerID
AND CallBacks.CallDate=" & TodaysDate
I have a Datetime data field i.g: 09/12/2002
I look forward to any input you make.
Regards,
Sam
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
