I am using a calculated field in a custom-list
=TEXT(Created,"yyyy-mmm-dd") to change the date format from the original
Created date field. At 99% of the time works correctly, but in about 0.4% it result an "1899.Dec.30.". (After 2500 element there are about 10) If I look on the original
Created column, the date is correct, only the calculated one is bad.
- How can I prevent this error happening?
- How can I refresh the value of these fields to show the correct dates everywhere? (Not an editable field)