WHERE Year(Bx_DOB) = #Year(Q_Date)#
AND Day(Bx_DOB) = #Day(Q_Date)#
AND Month(Bx_DOB) = #Month(Q_Date)#The above code, which is fine for Access, falls over under MySQL. Q_Date and Bx_DOB are valid dates. Any ideas why ? --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
