Dates in Confluence are wrong
Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
Confluence displays wrong dates for general events including page creation dates, history and comments.
Cause
Formatting and International Settings is wrongly set.
In the following example mm represents minutes so dates will be displayed in years-minutes-days resulting in 2015-54-17
Date Time Format yyyy-mm-dd HH:mm
Date Format yyyy-mm-ddSolution
Set the correct date format
Confluence can display wrong dates when the formatting setting is incorrect.
1. Select Settings (⚙️) in the top-right navigation bar to open Confluence administration. 2. Under Configuration in the left sidebar, select General configuration. 3. Scroll down to Formatting and international settings. 4. In the Date format (or Date time format) field, enter the correct format pattern. 5. Select Save configuration changes.
Use uppercase MM for a numeric month. In yyyy-mm-dd, lowercase mm represents minutes. This can result in a date such as 2015-54-17.
Time Format:h:mm a
Date Time Format: MMM dd, yyyy HH:mm
Date Format: MMM dd, yyyy
Long Number Format: ###############
Decimal Number Format: ###############.##########After setting the Date format, verify the result in a page creation date, history entry, or comment. Confirm that the displayed date follows the format you set.
Was this helpful?