Possibility to get current date in query

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

  • What are you trying to achieve?
    Trying to get the current date in my JSON API query string

pageSize=500&query=closed==true;operatorGroup.name==Helpdesk;closedDate=ge=2022-01-01T00:00:00.001Z

I would like to have the current date in the field below instead of filling in a date;

closedDate=ge=currentdate

In addition if possible, the date of yesterday or the first day of the week/month.
Is there any way to do this using a placeholder of grafana?

I’m new to this but after a lot of days frustrated searching, i haven’t found a solution yet.

  • How are you trying to achieve it?
    Lots of googling but not finding any answers or possibilities.

  • What happened?

  • What did you expect to happen?

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?

Hi @includes08,

Thanks for opening this post.

Could please attach some screenshots or maybe a screencast so that community users understand better what you are trying to achieve and how it looks in the UI?