Hello, everyone!
I've created a gallery in which its TemplateFill property indicates how close to ThisItem.Duedate the user is.
For this example, we'll assume Today() = 23/01/2024 in dd/mm/yyyy. So if an item's due date is 23/01/2024, their section in its gallery would be red (0 date difference). If it's 24/01/2024 it would be orange (1 day for it to expire). If it's 25/01/2024 it would be green (2 days to expire).
My problem is when this due date falls on a Sunday or Saturday, which I cannot control (These dates come from a SharePoint calculated column). Our company only works until Friday and it would be the last day of our workers to do something regarding the items expiring over the weekends, and I want to indicate this using by color. So if a Due date falls on Sunday, the section of its item will be painted green on Friday and I want it to be red. Can someone show me how to do it?
