Hi @Lisa.07
You can use app wide variable by adding field in users collection, such as tmp start time and update this field with a button and use them as filter.
To have equal to in expression, the field must be date (not date time).
So, my suggestion are as follow
- Add date field (not date time field) as additional field in your event collection, make this the same as event date time field
- Add date field again in users collection as tmp start time
- Put button for search that update this tmp start time
- Use this tmp start time as filter in your event list
If you still want to use date time as filter, you can check my trick about updating time according to timezone, so we get the whole day between 00:00 to 23:59.
Beware of the between in expression as the end point is not exact, I would rather use 2 expressions as replacement, greater than or equal to and less than or equal to.
Hopefully this reply make a little peace in your issue.