> If you always expect the default as mm/dd/yyy, and someone enters dd/mm/yyyy > you may end up with an invalid date, and your code might be trapping and > returning a default now(). There could be many reasons, for what is > happening.
I've got trapping that's being sure the date format is entered correctly. The form is calculating the number of travel days for a trip. So, if I enter 6/10/2007 as the departure date, and 6/19/2007 as the return date, what's ending up in the database is 6/09/2007 and 6/18/2007. The number of travel days is still being calculated correctly, it's just that the trip dates are off by one. I've also tried three drop-downs for month, day, year and then create a date from that. The above *still* happens. It's got to be something somewhere between the different time zones of the form itself, the CFC and the database on a different server in different time zones. Weird, huh? I'm hoping my "once an hour or so" test over the weekend will tell me something. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280528 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
