I have an admin set a time and date for an event. I want that event to be visible in a repeating group when eventdate=current date. How can I do this. (My time needs to be a separate input
There are a few ways to handle…here’s one:
Because date data types are actually always date AND time we need to select the entire range of time. In the < comparison we set the current date/time to a day forward and then bring it all back to zero’s on the time – this ensures we get everything including the last millisecond of that date. For the >= we are going back to the first millisecond of the current day.
This topic was automatically closed after 70 days. New replies are no longer allowed.