Formatting the Date type changes the year in the data [January]
Resolved
Hello,
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'
this happens:
'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?
Regards,
Dim
The same problem 
Hello,
This is a date format issue - please continue to use "yyyy" over "YYYY"
There is a useful blog post here that explains the difference:
http://www.juandebravo.com/2015/04/10/java-yyyy-date-format
Best regards,
Pete
Hello,
This is a date format issue - please continue to use "yyyy" over "YYYY"
There is a useful blog post here that explains the difference:
http://www.juandebravo.com/2015/04/10/java-yyyy-date-format
Best regards,
Pete
Ok, thank you for your quick answer! :)
Ok, thank you for your quick answer! :)
Replies have been locked on this page!