What Grafana version and what operating system are you using?
What are you trying to achieve?
I want to use relative time in a query
How are you trying to achieve it?
With this extra line in the query: WHERE Date BETWEEN ‘now/M’ AND ‘now’
And: With this extra line in the query: WHERE Date BETWEEN ‘now-30d’ AND ‘now’
Nothing, I get no data
What did you expect to happen?
I hoped I can select the data from this month with “Beetween”
what is your datasource? sql, influxdb, mysql?
I use a sqlite plugin
Could you post the full query and maybe even the dashboard export you have?