
Announcements
Hello,
So I have a gallery list with events and the dates they occur on, I want the dates that occur on a weekend to be highlighted in Green and the ones that are on weekdays in black normally. I keep trying a bunch of codes out but nothing is working for me.
What code should I be putting in the colors field to be able to only have the weekends as green?
Here are a few I have tried, that make the most sense to me, but still won't work:
If(Date(ThisItem.'Occurs On ') = Date("Friday" Or "Saturday"),Green, Black)
If(ThisItem.'Occurs On ' = "Friday" Or "Saturday",Green, Black)
How about formatting date as text then comparing text to text?
If(
Text(ThisItem.'Occurs On ',"dddd") = "Friday" Or Text(ThisItem.'Occurs On ',"dddd") = "Saturday",
Green,
Black
)