I have a dashboard that was producing inconsistent answers - breakdowns of the same set of records, but with different total numbers (which is obviously not possible). On investigating, I found an issue in the two date filters (filtering the same records on different date fields). We're in the UK, so we use international date formats, but one filter had mysteriously changed to US formats. Thus, 01/09/2025 - 01/10/2025 (1 September to 1 October) became (when I opened the filter editor) 09/01/2025-10/01/2025 (9 to 10 January).
Our whole system is set (obviously) to use international formats, and I set the filters up using the built-in date selectors. I'm not familiar enough with US formats to have entered them manually even if I tried. So they must have been entered correctly. How could values in one filter on a dashboard change format and the other not?
#Dashboards