bq: The requirement doesn't really let me use the query like that.
Why not? Why can't you index a start date and end date? At ingestion
time if your data is a start date and number of days the event (let's
call it an event) will run, why not index a second field that contains the
end date along wi
Thankyou Erick,
The requirement doesn't really let me use the query like that.
Rather, what I would be storing in my document is the day number.
E.g: Day : 1, Day : 2 etc I can even store this in milliseconds
like 8640,17280.
And I want to compare if those days falls within the differen
I wouldn't do it this way, it's far more complex than you need. Try
fq=Startdate__D:[NOW/DAY-7DAYS TO NOW/DAY+1DAY].
Why the weird NOW/DAY+1DAY? Well, that makes fq clauses far
more likely to be reused, see:
https://lucidworks.com/blog/2012/02/23/date-math-now-and-filter-queries/
Best,
Erick
On
