At 12:16 PM 1/27/03 -0500, Frank Mamone wrote: >What is the nest way to format a date to compare to a database datetime >column.
I always use CreateODBCDate(). So I can do something like: <CFSET RequestDate=CreateODBCDate(CreateDateTime(Year,Month,Day,Hour,Minute,Second))> <CFQUERY...> Where dateColumn < #RequestDate# </CFQUERY> Works everytime (for me) and you don't have to worry about date formatting. T ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4