Blog post_date format error

sldavidson

When creating a new blog post, the post_date date format appears to be wrong somewhere in the JavaScript / jQuery as dd-mm-yyyy gets parsed as mm-dd-yyyy.

Therefore Sunday 13th October is getting parsed as 10-13-2013 instead of 13-10-2013 which results in 1970-01-01 01:00:00

I'm assuming it's the JS, because adding:

die( '$_POST<pre>' . print_r( $_POST, TRUE ) . '</pre>' );

...to the start of the on_before_save method in blog_posts_model gives the same date.

Any ideas?

admin

Is this using FUEL .93 or the FUEL 1.0 beta with the blog module installed (they are separated out in 1.0)?
https://github.com/daylightstudio/FUEL-CMS-Blog-Module

Also, to be clear, you are wanting your date picker to have the date format of "dd-mm-yyyy" correct?

sldavidson

Sorry it's Fuel 1.0 and the date format I want is dd-mm-yyyy which is correct in the JavaScript datapicker, it just gets parsed thereafter as mm-dd-yyyy which is where the problem is arising.

admin

This has to do with how strtotime interprets dates with "-" instead of "/":
http://www.php.net/manual/en/function.strtotime.php

sldavidson

Thank you Mr Admin, I will have a further look into this and see if I can figure out what's going off.

sldavidson

Fixed this by amending the following in fuel/application/config/My_config.php:

$config['date_format'] = 'd/m/Y'; -> $config['date_format'] = 'd-m-Y';