Hi all
I would like to change the container fill color based on the label text that contains an email address using the "in" function also like to use a switch function how could I use both for the fill properties for container?
code currently
Switch(
true,
DateDiff(
Today(),
DatePicker1
) < 6,
Color.DarkRed,
DateDiff(
Today(),
DatePicker1
) > 6,
Color.DarkGreen,
DateDiff(
Today(),
DatePicker1
) = 6,
Color.DarkGreen
)

Thank you