>I think you may be missing some pound symbols as I am not aware that >MySql has a datepart function. > >Cheers, >Dan > >On Feb 1, 2010, at 6:44 PM, Chad Veldhouse <cveldho...@vaagency.com> >wrote: > >>
Maybe I am mis-understanding the functions. Is DatePart a function of MS Access? Is that why it wont work? If I use "Extract" it works. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:330324 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4