microflow comparing dates

For a schoolproject we have to make a room boeking system. im trying to make boeking that already happen (ie in the past) to set them with a boolean attribute named active from yes to no. i have tried to do this with a microflow and failed. i dont kow how to do this? in essence i want when a boeking that was on 13/6/2023 go from active yes to active no.
1 answers

Hi Vincent,

You can run a scheduled event every midnight that retrieves all bookings that should be set to inactive. Something like

[BookingDate < [%CurrentDateTime%]]

Then loop over them, set them to inactive, and commit the list.

Hope that helps.