Im just looking at setting up a reminder system for clients scheduled appointments. Ive decided to use the report scheduling and fire appointment reminders at 2pm, looking to see if it can see appointments that are between 34 and 58 hours in the future. I made this formula but I’m not sure wether its correct as the expression helper changes the 034:00:00 to 1.10:00:00 and 058:00:00 to 2.10:00:00
does it not like me using hour increments greater than 24hours?
This is my current formula:
IF(AND([Start DateTime] >= NOW() + “034:00:00”, [Start DateTime] <= NOW() + “058:00:00”),True, False)