Possibly because createodbcdate('12 March 2004') defaults to midnight, and
now() retains the time today aswell, I just tried it and it's about 10:30,
with the difference being 38000 secs, which looks about right?
Yep that seem to be what happening - but when you output the variable you
don't get the time part - it's slightly odd. Seems it's a date in some
cases and a date/time in others.The fix is to put dateformat around the now() but I'd still like to know if this is expected behaviour or possibly a bug in CF.
Justin ============================================= Justin Mclean Class Software Phone: (02) 93321230 9 Chapman St Fax: (02) 93321032 Surry Hills Mobile: 0416 119 342 NSW 2010 =============================================
--- 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
