Set Visibility rules for a due date?


I have been trying to figure out a solution for the visibility of certain tiles depending on the time. I am looking to create 3 types of categories each with their own tile. I also have the date settings for their previous appointment and then when the next appointment is due.

I am looking to make the background gray if the due appointment is between the “previous PHA date” and 9 months from the “previous PHA date”.

A the 9 month mark the background color will change to yellow or a new rectangle appears ‘to the front’ of the gray rectangle between 9 months from the “previous PHA date” to the “PHA due” date

At after the PHA due date the background becomes red or a new red rectangle appears to the “front of the yellow” rectangle.

This is what I have so far for the set up…

Thank you for your help in advance!

Here is the lay out of the rectangles…

Here is my database. I would like to have this set up off of the PHA Due.

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.