DateTime Variables Not Working On Public Dashboards

Grafana Dashboards
1

Hi,
Current using Grafana v10.2.0 (895fbafb7a) and I’m having an issue with public dashboards. I have a dashboard using SQL server as a data source. In the query for one of the bar charts I’m using ${__from:date:iso} and ${__to:date:iso} to limit the query. This works perfectly and if I change the time range at the top of the dashboard the charts update. The dashboard is being designed so it can be shown on a wall TV in our office, therefore i need to make this dashboard public. The problem comes when I make the dashboard public the variables stop working.

For example - this is the non public version:
image

And this is the public version:
image

The SQL query behind this panel is:

Select '${__from:date:iso}'

Any ideas what I doing wrong?

Thanks