Correct 'date' format?

6 posts by 3 authors in: Forums > CMS Builder
Last Post: January 14, 2016   (RSS)

By tbernatonis - January 7, 2016

I use CMS to create date specific news feeds which need to be listed in order on my website. What is the proper format to enter the date so it lists in order. It doesn't seem to take the year into account.

For instance, 01/12/2016 would be listed chronologically before 12/31/2015 because the year is not taken into account. I noticed if I spell out the month, it goes alphabetically.

Any feedback would help. Thanks!

By Damon - January 8, 2016 - edited: January 8, 2016

Hi,

If you are typing the date in manually to a text field, it is being sorted alphanumerically. Also, if the date isn't entered in a consistent date format, this could cause issues.

The best way to handle and sort dates correctly is to use a date/time field type and then sort on that. 

Let me know if need more details and if this will work for you.

Thanks!

Cheers,
Damon Edis - interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By Damon - January 13, 2016

Speaking of date formats, it would be great if we could choose the ISO format yyyy-mm-dd

Where were you wanting to see this date format: the frontend, section editor index page or section editor modfiy page?

Cheers,
Damon Edis - interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By kitsguru - January 13, 2016

Front end is not a problem as that is easily controlled. Backend is what I was referring to and it matches the default for MySQL as well.

I was actually referring to the General Settings option for date format.

Jeff Shields

By Damon - January 14, 2016

Hi Jeff,

The Date Field Format default option sets date to be YYYY-MM-DD in the Section Editor Index page. It doesn't change the date format that is entered on the create/edit record page. That stays as MM-DD-YYYY. I will add this to the update list for CMS Builder.

Cheers,
Damon Edis - interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/