I was able to do a search for event on a repeating group for a specific date but now it’s not working.
This is what I have set up but it is not working. Can anyone help?
I was able to do a search for event on a repeating group for a specific date but now it’s not working.
This is what I have set up but it is not working. Can anyone help?
What do you mean it’s not working?
It’s not showing the event when I preview it.
Are you sure there is an event matching the constraints?
Post a screenshot of what the debugger shows, and/or your database.
When you’re working with dates, they are very precise so it’ll look for a date that matches exactly the date to the second. I think you need to search events that are between to dates going from 12:00AM to 12:00PM.
Can you show a screenshot of how I should do that?
startTime >= Date Time picker’s value
startTime < Date Time picker’s value +days(1)
Thank you but this did not work
It looks like your Start date/time and End date/time fields are text instead of dates… is that true?
they are dates
What does the search for events show?
This is what it has for my initial setup
And for George suggestion
Both came back empty.
Well there you go then…
The start date of the Event in your database is 14th September 2023, 10:00am
In your first search you’re searching for events who’s start date is 5th October 2023, 12:00am
Andin your second you’re not searching for anything (the start and end dates are empty)
So there are no matching results in either case.
You can inspect further down to see why your dates are empty. This should work.
I’m not sure why it’s searching for an event in October. How can I correct it?