Issue Dates are Incoherant

Question

Both my custom date fields and my system date fields are behaving strangely.

I'm getting impossible dates / times, like "45/14/2023 4:45 PM", "41/29/2023 6:41 PM" or "00/08/2023"

I've checked our SQL database, and the dates are being recorded correctly. So, the issue must be somewhere between the java and JavaScript interactions?

Here are my current date-related System settings.

"Look and Feel" Day/Month/Year format is set to the "mm/dd/yyyy" format.

My "Advanced Settings" are:

jira.date.picker.java.format: "mm/dd/yyyy"

jira.date.picker.javascript.format: "%m/%d/%Y"

jira.date.time.picker.java.format: "mm/dd/yyyy h:mm a"

jira.date.time.picker.javascript.format: "%m/%d/%Y %l:%M %p"

Any ideas how to resolve this?

Trudy P Claspill · Answer

Glad I could help.

If your problem has been solved with the help of my response, please consider clicking on the Accept Answer button above the response.

S_ B_ Sebrick · Answer

Thanks, that was a big help!

Trudy P Claspill · Answer

Hello @S_ B_ Sebrick

Welcome to the Atlassian community.

"Look and Feel" Day/Month/Year format is set to the "mm/dd/yyyy" format.

In that context a lower case "m" means minutes, not month. To get month data you need an upper case "M". And that setting formats the display of date-only data. date/time data is formatted by the settings for Complete Date/Time Format

What is the "Look and Feel" settings for Complete Date/Time Format? That is what formats the display of date/time information. Again, in this setting you need to use M's for month, and m's for minutes. And I suspect you don't have the correct syntax there for days.