Bug with date format

[tristanleboss]

I use a French WordPress installation with latest Pods and latest WordPress.
This is NOT a regression due to the date fix present in 2.7.14: the bug is here since a long time.

I have a "Date/Time" field set to use format "d/m/Y" ("dmy" is the select option value).

Capture done on July, 13th:

If I create a new content, it seems to work (I choose July, 8th):

If I save, I get this in the database (still July, 8th):

But, if I come back to the content, the date is wrong (July, 8th became August, 7th):

My WP Settings > General:

[issue-label-bot]

Issue-Label Bot is automatically applying the label Type: Bug to this issue, with a confidence of 0.97. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

[tristanleboss]

The issue is from the code that render fields on a content page:

As seen on this screenshot, the value of the input field is wrong. We can see, the jQuery date picker is configured correctly.

[tristanleboss]

To trigger the problem, you need to use an ambiguous date (with both day and month <= 12).

Indeed, if you use August, 21th, the input value will be set correctly to 21/08/2019. It's only wrong when you use ambiguous date.

[JoryHogeveen]

@tristanleboss

I've been unable to reproduce your issue on my local installation.
Could you please test with WP Site Health enabled (under Tools). Please only enable Pods and test again.
If the problem still occurs please share some more info about your installation:

• WP version
• Other plugins
• Browser
• PHP version
• etc.

Thanks in advance!

[tristanleboss]

Hello, I will retest this next week on a fresh WP install ;)

[JoryHogeveen]

Hello @tristanleboss

Forgot this issue.
This is probably be related to a "larger" issue with date fields and has been fixed in PR #5451
If you could also test this that would be great!

Thanks, Jory