Help me to refine this query

[Jenni]

@pk.241011

but it did not work:

What did it do? This should give you the documents between midnight of the day before and midnight today. (I don't know why the format parameter is there when only relative times are used in the query, so the format isn't used anywhere?)

@pk.241011

But now still had the time part

What do you mean?

@pk.241011

Is there any way to round off now to nearest hour

You could use /h instead of /d to round down to the hour instead of the day. That is explained in the date math documentation that is linked in the article mentioned above.

---

Edit: As a side note: You could have mentioned that you've already got a topic for this. Didn't setting the time_zone help?

How to fix this date range

Hi, Here is sample code from the documentation: GET /_search { "query": { "range": { "timestamp": { "gte": "now-1d/d", "lt": "now/d" } } } } I want to change it so that now only uses the date part and not the time. My usecase is to get previous day data for 24 hours e.g Between 00:00:00 and 23:59:59. In other words the range should be [28-07-2020 to 29-07-2020]. Is there any extension on now like now.Date? I was looking at painless script but not su…