Search for event with a specific date

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?
Screenshot 2023-09-13 at 8.51.28 AM

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.

My database is showing start date and end date.

The debugger

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

Are you certain? Show us a screenshot of your data type from the Data tab.

Screenshot 2023-09-13 at 9.12.17 AM
Screenshot 2023-09-13 at 9.12.33 AM

What does the search for events show?

I’m looking for a screenshot like this:

This is what it has for my initial setup
Screenshot 2023-09-13 at 9.15.27 AM

And for George suggestion
Screenshot 2023-09-13 at 9.14.24 AM

Both came back empty.


Screenshot 2023-09-13 at 9.18.18 AM

Well there you go then…

The start date of the Event in your database is 14th September 2023, 10:00am

image

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.

Capture d’écran 2023-09-13 à 16.19.24
Capture d’écran 2023-09-13 à 16.19.35
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?