Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

'Created' and 'Updated' column showing invalid/wrong dates.

Rasik Aryal
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 9, 2022

JIRA showing wrong dates.PNG

When I add 'Created' and 'Updated' column, the dates shown are wrong/invalid. For example, in the picture above, I sorted the created date by latest to oldest. The date shown are 47/08/2022. What is that format?? What is 47 supposed to be? How to i make it shown DD/MM/YYYY format?

1 answer

1 accepted

0 votes
Answer accepted
Trudy Claspill
Community Champion
November 9, 2022

Hello @Rasik Aryal 

Welcome to the community.

The format for displaying those dates is a System level configuration setting. Your Jira Administrator would be able to modify that. 

The setting can be found under the gear icon (Settings) > System > Look And Feel.

It is the Date/Month/Year Format setting on that page.

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 9, 2022

The formatting strings are free text, so open to errors.

My guess would be someone put in "m" instead of "M", so you are getting "minute" instead of "Month"  (in what should be the day field)

Like Trudy Claspill likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events