I have not been able get a time series or xy report to ever work if I do any formatting with the date…I end up using a bar chart but that is not always the best way to display the data…I put some time and effort in today to try and get it to work, but I always end of with all of the data plotted in the center of the chart with the 1970 epoch date. Here is an example query…
SELECT CAST([datefield]) as DATE, COUNT(somefield])
GROUP BY CAST([datefield]) as DATE
The date returned looks like “05/21/2019” I always get what looks like good data, and like I said, the bar chart always works properly
Any thoughts? I would think if it did not like the date format that an XY chart would work, but it produces the same result!