<cfquery name="rs_getArticles" datasource="#your DSN"> SELECT * FROM your table ORDER by articledate
</cfquery> the output it: <cfoutput query="rs_getArticles"> #DateFormat(articledate, "mmmm d, yyyy")#<br> #articleTitle# </cfoutput> John On Aug 23, 2009, at 4:09 PM, Barry Mcconaghey wrote: > > 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:4751 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
