I use the date and time on my website but I need to sort by date in my admin section.
>I would recommend convert your date/time in your table in Date format only. > >For example, if you are using MS SQL server, you can do that like: >**************************************************************************** >SELECT convert(varchar(10), articledate, 101) as articledate >FROM yourtable >etc...... >ORDER BY articledate >*************************************************************************** >That will convert your "2009-05-12 20:16:44" to '05/12/2009' > >Then you can use GROUP attribute in your OUTPUT: >*************************************************************************** ><cfoutput query="articles" group="articledate"> > #DateFormat(articledate, 'mmmm dd, yyyy')# ><cfoutput> >*************************************************************************** > >Regards, >Misha > > >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:4756 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
