[BUG 4.7.12] Revisions for CMS Database Date fields show the timestamp rather than a formatted date

[teraßyte]

When adding a Date Field to a database that stores revisions, the comparison shows the timestamp rather than a formatted date.

 

Here's an example:

Quote

Date

===

Revision
1691971200

Current
16919712057600

A revision showing the above doesn't help, especially if the user doesn't know that that "weird number" is actually a timestamp.

A formatted date using the member's locale should be shown instead, including the time if the field option is enabled.

Edited August 14, 2023 by teraßyte

[Marc]

Where exactly is it you are seeing this occur?

[teraßyte]

You need to click the Revisions link when viewing the record where the field was changed:

 

And this is what the Revision page shows:

[Marc]

Thank you for bringing this issue to our attention! I can confirm this should be further reviewed and I have logged an internal bug report for our development team to investigate and address as necessary, in a future maintenance release.

 

[Marc]

This issue has been resolved in our recent 4.7.14 release of the platform. Please upgrade to resolve the issue, and if you see any further problems at that point, please let us know.