> Seems really odd, have tried #createodbc(form.date_entered)# but get the same > error occuring.
Probably what's happening here is that CF (instead of the db) is assuming US format so causing the same problem. Unless you use LS functions, CF always assumes US format, which means most users of CF are blissfully unaware of these problems. I know many of my early apps only worked properly from the 13th of every month onward. Apparently I did my bug checking at the end of the month. ;-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230384 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

