Format Date Format

2 posts by 2 authors in: Forums > CMS Builder
Last Post: July 18, 2017   (RSS)

By brucebrown - July 15, 2017

I have set the date format to be "Day Month Year" from the General Settings page.

Can someone please tell me where the date format applies?When I view system fields such as "createdDate"  and "updatedDate" they are still displayed as "yyyy-mm-dd hh:mm:ss"

By Dave - July 18, 2017

Hi brucebrown, 

Welcome to the forum!  

It applies in many of the pages in the backend CMS.  The YYYY-MM-DD HH:MM:SS format is how it's stored in MySQL so you'll see that when outputting dates in the viewers.  For most date fields you can format them like this in the viewer code: 

<?php echo date("D, M jS, Y g:i:s a", strtotime($yourRecord['date'])) ?><br/>
<!-- For date formatting codes see: http://www.php.net/date -->

Let me know if that works for you or if you see anywhere where the date isn't formatted the way you think it should be.

Cheers!

Dave Edis - Senior Developer
interactivetools.com