Title: Dateformat. Sorting
Last modified: November 29, 2016

---

# Dateformat. Sorting

 *  [LarsHdg](https://wordpress.org/support/users/larshdg/)
 * (@larshdg)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/dateformat-sorting/)
 * Hello,
 * I must praise this plugin – serving as a great DB for entries to our site.
 * But 2 issues / bugs in the entries listing for a CF7 form:
    [IMG](https://www.dropbox.com/s/5kqy9j47gbxqklg/2016-11-29_14-46-22.png?dl=0)
 * 1) As you can see from the screen clipping the submit date looks weird: Day and
   Month is double – Year is tripled ??
 * 2) In this table there i some 300 entries. When sorting on a field with unique
   numbers ascending, it only sorts the first 100 entries. And as shown the first
   one might not be “the first in the list”?? Going to the next page (101-200) will
   look the same.
    So the sorting does not sort the whole list.
 * What and how to overcome this. The sorting in particular is a problem.
 * Thanks a lot in advance.

Viewing 1 replies (of 1 total)

 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/dateformat-sorting/#post-8495292)
 * 1. On the CFDB Options page, change the date format to how you would like it 
   to be.
 * 2. The administration page will only sort what is on the page. On the CFDB Options
   page, you can set how many rows are loaded into the page at a time.
    PS. A shortcode
   will sort across the whole data set.

Viewing 1 replies (of 1 total)

The topic ‘Dateformat. Sorting’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff.
   svg)
 * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/)

## Tags

 * [date format](https://wordpress.org/support/topic-tag/date-format/)
 * [sorting](https://wordpress.org/support/topic-tag/sorting/)

 * 1 reply
 * 2 participants
 * Last reply from: [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * Last activity: [9 years, 5 months ago](https://wordpress.org/support/topic/dateformat-sorting/#post-8495292)
 * Status: not resolved