Formatting the Date type changes the year in the data [January]
we just faced a weird issue in our reports that use a Date Field.
The data look like the picture:
The problem exists with January, 01-01-2017.
When we change the data format to 'Other' and custom date format to 'MMM-YYYY'
'01-01-2017' is translated to 'Jan 2016'.
We actually had the reports in PRODUCTION, we did an update to 7.3 recently and the users reported that. In ACC, the problem didn't occur so it's kind of hard to replicate it I guess.
In order to solve it, I changed the Custom data format to 'MMM-yyyy' (small letters vs. capitals) and the result was correct:
Do you maybe know what causd the issue and how cna I prevent that from happening again?