I want to show the number of events on a particular day. I had it set up as follows but this doesn’t show events that are spanning over that particular day:
How do I search for ‘events’ that start before and end after, but include that particular date?
For example:
Date I want to search for 31st May 2024
A ‘holiday’ event starts on 20th May and ends 3rd June. I want to show that there’s 1 event on 31st May
Assuming the dates are being stored properly in terms of time zones, for event start time modify event date :change hours to 0:change minutes to 0: change seconds to 0 and for event end time, modify event date :change hours to 023:change minutes to 59: change seconds to 59 (or based on use case add a day and set that day to 0/0/0)
Thank you, so how do I search if there’s any events that contain that date?
Oops misunderstood. You would probably need to use a date range for that and search for events that contained the search date’s date. Although if you’re using this in a calendar setting, you may want each date covered by the holiday (5/20-6/3) stored in a list of dates within the event.
Thanks @code-escapee 
I’ve never actually done a search for date range before. What parameters do I need to add to search for events that contain a particular date please?
have a data range field on each event that is set to begin with event date and time and end with event date and time.
Regarding the search, I haven’t done that recently but basically search events that contain searching day (either both 0/0/0 and 23/59/59 OR just any time in the searching day if all events are full days)
This topic was automatically closed after 70 days. New replies are no longer allowed.
