Hey Mark I've just dug through some code & found that I'm running:
date_format(max(orders.orderDate),'%Y-%m-%d') ...and... ltrim(max(orders.orderDate)) Both of which seem to work (CFMX 6.1 & MySQL 4.0.12). Cheers Mark ------------------ Mark Stanton Technical Director Gruden Pty Ltd Tel: 9956 6388 Mob: 0410 458 201 Fax: 9956 8433 http://www.gruden.com --- 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
