Can you add a scheduled event to your application which checks the time every hour and changes the status accordingly? That would be an easy fix.
Hi,
We can add Minutes , Hours and days using date functions to current datetime.
Ex:
addMinutes(dateTime(2007, 1, 1, 1, 1, 1), 3)
Please refer the below link for more information.
https://docs.mendix.com/refguide/add-date-function-calls. i would prefer to sort the time from DateTime and compare.
Ex: Formatdatetime($Datetime,’HH’) Find below link for more information.
https://docs.mendix.com/refguide/parse-and-format-date-function-calls
Hope this helps!