query for documents with datetime field where time is outside office hours. There's a field vraag_datumtijd (same format as @timestamp) that's filled with a date time stamp of the moment of doing an user action and a field username. I would like to query the documents of yesterday and show the user…

This is probably better achieved with negating the condition (not in working hours) to avoid date math. You can use a boolean query with a must_not clause for the working hours, which is effectively used as a filter. Something similar to: { "query": { "bool": { "must_not": [ {…

Query for documents with datetime field where time is outside office hours

Elastic Stack Elasticsearch

Peter_K (Peter K) April 3, 2024, 11:13am 5

Great. That's working. Thank you very much for your help with this.
How can I close this topic or mark it as complete?

Topic		Replies	Views
How to filter date field by days and hours separately Elasticsearch	6	7830	September 3, 2019
Trying to do a simple query filter Elasticsearch	6	1074	April 2, 2019
Filtering by date and time as different fields Elasticsearch	10	13295	July 5, 2017
Time range query on date field Elasticsearch	2	610	November 3, 2017
Filtering by Range Elasticsearch	5	6993	January 26, 2018

Query for documents with datetime field where time is outside office hours

Related topics