Page 1 of 1

TIP: Formatting appointments

PostPosted: Wed Nov 07, 2007 1:17 pm
by Court Bowman
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.