In the sample you posted, DatePart() is not surrounded by hashes (#). This means that you are calling the database's DatePart() function. Apparently MySQL does not have such a function, which is why you are receiving the error message. (I do not use MySQL, so you'd have to check their documentation to find the appropriate function(s) to use.)
Conversely, if the code is actually #DatePart()#, then you would be calling a CF function. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330325 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4