Hi Daniel This is a long shot but....
What is the data type of the logdatetime column? If its datetime format or some other non string format - that might be your problem. Try using DATE_FORMAT (http://www.mysql.com/doc/en/Date_and_time_functions.html) instead of the left & replace functions. As for double or single quotes, I've never known mysql to be picky. Cheers Mark ______________ Mark Stanton Web Production Gruden Pty Ltd Tel: 9956 6388 Mob: 0410 458 201 Fax: 9956 8433 www.gruden.com --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
