The year of a date increments by 1, when the date format is changed to "dd MMM YYYY". For example, if the date before changing the format is "12/26/2021", after changing the format, it converts to "26 Dec 2022". This is noticed in Adhoc Views. Why does this happen?
This is working as expected since "Y" (upper case Y) is interpreted as the "Week Year" by Java. Whereas, "y" (lower case Y) is interpreted as the "Year". It is the upper case Y that is used by Adhoc Views when the format "dd MM YYYY" is selected in the front end.
In the example above, since 26th of December of 2021 is within the first week of 2022, the year that is returned is 2022.
In comparison, 25th of December 2021 does not share a week with 2022. So, the year returned is 2021.