"now" isn't working in a query

  • What Grafana version and what operating system are you using?
    9.3.1

  • 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’

  • What happened?
    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