Hello. How do I group data by date when the date format in my table is a date and time format. (2009-05-12 20:16:44).
I would like to sort or list all the articles for each day. But it is not working because the time is different for each article but the dates are the same. <cfoutput query="articles" group="articledate"> #DateFormat(articledate, 'mmmm dd, yyyy')# <ul> <cfoutput> <li> #articleTitle# </li> </cfoutput> </ul> </cfoutput> Thanks! Barry ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-newbie/message.cfm/messageid:4750 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
