How to Set Earliest and latest in Query

[shugup2923]

I have a query in a dashboard, which needs to be run from 15th of last month to 14th of current month, how can I set this timerange in my query so whenever it runs it takes timerange between 15th of last month to 14th of current month.

for ex-
Time Range for running the query should be (2/15/20 12:00:00.000 AM to 3/14/20 12:00:00.000 AM)

[gcusello · Accepted solution]

Hi @shugup2923,
Try

earliest=-mon@mon+14d+12h latest=@mon+13d+12h

Ciao.
Giuseppe

[shugup2923]

thanks , it worked. this is a good way to give time. Thanks so much.

Keep Splunking 🙂