>>#dateformat(FORM.start_date, "MM/DD/YYYY")# Several things here: 1) dateFormat needs a date in its first argument, so CF will first convert FORM.start_date, which is a string, to a date value. 2) thus CF will suppose that FORM.start_date is in american format. But then dateformat is useless since it formats the date back in american format. 3) Not sure Access will take a date in american format. Better use createODBCDate() like in: DateReceived >= #createODBCDate(FORM.start_date)# and it will be safer to make sure that FORM.start_date is a valid date in american format.
-- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293439 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
