Hi
I have an App and I want a Label change color to yellow after 12 hours
and then changes to RED after 24 hours. What is the best TimeValue or DateDiff i can use for that?
The below function isn't working for me
If(DateDiff(ThisItem.Date, Today(), Hours) > 24, OrangeRed, RGBA(0,0,0,0) &&
DateDiff(ThisItem.Date, Today(), Hours) > 12, Yellow, RGBA(0,0,0,0)
)