List View sort by date 2 years 10 months ago #232209

  • tyekynan's Avatar Topic Author
  • tyekynan
  • Offline
  • Senior Breezer
  • Senior Breezer
  • Posts: 148
  • Karma: 1
  • Thanks: 3
Hello, I have been having issues sorting my list view by date.

Currently, my date format is mm-dd-YYYY.

When I choose the date column to be sorted, it seems to only sort the years as the months and days are in no particular order.

How can I correctly format my date as mm-dd-YYYY and it sort from now until infinite, in order.

Please Log in or Create an account to join the conversation.

List View sort by date 2 years 10 months ago #232216

  • mihaela
  • Offline
  • Developer
  • Developer
  • Posts: 3128
  • Karma: 105
  • Thanks: 415

Go to View tab of the view that you've created and click on Advanced Options.
Then you can set Initial sort order based on calendar filed that you want.
The issue with this is that it orders values alphabetically, it doesn't recognize that Calendar field with dates is in question.

Therefore, the only way to have records ordered by dates inserted in calendar field is to use YYYY-mm-dd format instead of the one you are using now. In that case, dates will be properly sorted.

Let me know whether this helped.



Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Moderators: ForumSupport
Time to create page: 0.041 seconds

BreezingForms Pro 1.4.7 for WordPress Released!

Available in the membership section.

September Discount!

Massive discounts on all subscriptions!

Get Your Subscription Here

Quick Links










Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

Questions et réponses sur les forums de l'AFUJ


Special Offer

Summer Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!