You need to convert the date format to: YYYY-MM-DD:
http://www.mysql.com/doc/en/Using_DATE.html At 08:38 PM 12/8/2002 -0500, [EMAIL PROTECTED] wrote:
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)
-- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.com/ --------------------------------------------------------------------- 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
