Simple Casting or Date Formatting Question

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.

I typically return the day as a number in the query and then use that.
Just simplifies things.

I’m not sure I understand what you mean. As a number in date format or as an integer?

Sorry yes as an integer.
SELECT DATEPART("d",MyDateField) as DayNum
Then use DayNum as the axis value.

That makes perfect sense.

Thank you!