MySQL has a Year() function which would achieve what you want by the looks of it:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function _year Will -----Original Message----- From: Matt Quackenbush [mailto:[email protected]] Sent: 02 February 2010 02:30 To: cf-talk Subject: Re: DatePart Function Missing 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:330326 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
