KQL Query or Elastic query to fetch data for current month

Elastic Stack Kibana
1

Hi all,

I'm trying to fetch data only for current month of april 2023.

For example,

I have a query filter condition in my search bar in my kibana data table as

configuredDate > now-30d

which gives me data for past 1 month.

But I want to fetch data from April 1st to April 28th 2023.
The above query fetches me data from March 30th 2023 to April 28th 2023.

I want to fetch data from 1st of the current month to current date for other queries.
This data may dynamic , but i want to fetch from 1st of current month i.e from April 1st 2023 to April 28th 2023 or current timestamp.

I cannot use timepicker for this.

Screenshot 2023-04-28 at 3.04.57 PM
Screenshot 2023-04-28 at 3.04.57 PM1411×582 39.8 KB

Any way to go about it?

Regards

2

See if now/M gets you what you want. That should round it down to the nearest month.

3

No, the below throws an error.

configuredDate > now/M

Any other way I can show present month

4

So instead of using KQL, could you put the time relevant part in the query DSL. Here's the query I'm using:

GET example/_search
{
  "query": {
    "range": {
      "@timestamp": {
        "gt": "now/M"
      }
    }
  }
}
5

@Wave Thank you!

I tried in DSL query and it worked as below:

{
  "query": {
    "range": {
      "configuredDate": {
        "gte": "now/M"
      }
    }
  }
}

I just had to change from gt to gte & it worked!