Absolute time in grafana queries

Hallo everyone,
I try to make dashbord with monthly energy consumption data, but unfortunataly InfluxDB doesnt support M range. Is it any way to do it?
Or how to use absolute time in grafana query. “where time>2021-01-01 and time<2021-01-31” doesn`t work.

  1. Grafana does support the concept of a month:
  1. You probably just need to ensure that the dates you enter are in the
    correct format for InfluxDB to understand: