I have an SQL query that returns values averaged by day. I want to plot them on a chart to show the trend.
My values come from a transaction group, so they are saved with a time stamp that I CAST as Date.
When the values are summarized by day, the x-axis date I get back is like Aug 27, 2020 12:00 AM.
My chart ends up with hours of the day on it, but I want just the day.
I can get the format looking right by using CONVERT, but then the chart chokes on it because it wants a time instead of a string.
Is there something I can do to just get the date returned when I cast as date, or should I convert to string and then change my chart to treat the dates like categories? Or is there something else I’m missing here?
Thank you.