Hello, I have three fields: date_start (type: date) date_end (type: date) permanent (type: bool) I would like to return all documents with theses conditions: date_start <= now AND date_end >= now OR date_start <= now AND permanent == true What is the best way to do that ? I thought it would…

@Quentin_L_eilde Since you haven't mentioned format for the date_start and date_end, I am assuming default format which is "strict_date_optional_time||epoch_millis" However your "now" is in seconds. It should be in milliseconds. if param "now" is refers to current timestamp then you can pass word…

Discuss the Elastic Stack

How to get current time as unix timestamp for script use

Elastic Stack Elasticsearch

system (system) Closed August 12, 2020, 2:46pm 4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Current Time Elasticsearch	3	653	December 14, 2017
Current time value in ES? Elasticsearch	3	1196	July 6, 2017
How to fix this date range Elasticsearch	4	1409	August 26, 2020
Get Current Time and date Elasticsearch	3	28001	February 26, 2018
Searching by date range on field having timestamp doesn't returns me documents Elasticsearch	2	893	July 6, 2017

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

How to get current time as unix timestamp for script use

Related topics