I am trying to use the DatePart() function as part of a normal SQL query using Access DB. The SQL statement is formatted correctly to extract a month from a date field in the DB, and the SQL tests fine in Access. However, it does not work in cfquery. I then realized that CF uses the same function as part of its own reserved function library. Looks and works pretty much the same as the SQL version, except the reference shows it primarily to format output of Date/Time and NOT used in SQL. I would like to use it to sort by month and year.
How can I use this in a SQL statement without CF thinking that it owns the function? ...what am I missing here? Kevin ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:274335 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
