All,

We had a client ask how to format an appointment to turn red after the time for the appointment was over, essentially if it was in the past.

The following calculation placed as custom formatting on any appointment based on the perspective of CalDailyAppointments will trigger true when the appointment is in the past, FWIW.

This is for the free version, but should work on any version of the product.

Code: Select all

CalDailyAppointments::ApptDate < Get ( CurrentDate ) or ( CalDailyAppointments::ApptDate = Get ( CurrentDate ) and Max (CalDailyAppointments::ApptTimeEnd ; CalDailyAppointments::ApptTimeStart )  ≤ Get ( CurrentTime ) )


I hope it helps someone.