Sort Order by Date

4 posts by 3 authors in: Forums > CMS Builder
Last Post: February 12, 2009   (RSS)

Am confused about setting up sort order for listings of items that will be identified by date. Will sort work on this format field? January 2006 Quick Tip, February 2006 Quick Tip ....January 2009 Quick Tip. If so can I specify descending order to have most recent first? Need to list Quick Tips by date and not sure how to accomplish this after reading online documentation.

Re: [ThreeTree] Sort Order by Date

By Kenny - February 12, 2009

The easiest way is to create a date field and set your sorting to date DESC

Then on you page code you could put this

<?php echo date("F Y", strtotime($record['date'])) ?> Quick Tip

This would translate to Read January 2009 Quick Tip

Make Sense?


Kenny

Re: [sagentic] Sort Order by Date

Don't understand contents of date field so that sort will be by month within year. Is this an additional non printed field in the database? I am confused!