Answered

Change fill colour when date past

(0) Share

Report

Posted on by Benson23

Hello ,good evening. I have run in to a bit of a problem , so close.

Switch(
true,
DataCardValue14.SelectedDate < Today(), Color.Red,
DateDiff(Today(), DataCardValue14.SelectedDate, Months) >= 1, Color.Orange,
true, Color.White
)

In this formula when no conditions are met doesn't want to default to white , stays on orange ,

when due date has past todays date the red works .

puzzled .

any guidance appreciated please

All responses (7)

Answers (1)

DJ_Jamba 2,822 Super User 2025 Season 1 on at

Like (0)

Report

Re: Change fill colour when date past

No probs and glad it's solved!
d(-_-)b
Benson23 18 on at

Like (1)

Report

Re: Change fill colour when date past

Thank you . @DJ_Jamba . you are correct , I realised what id have done wrong , i needed orange to be 1 month leading up to the due date . my mistake .
kind regards
benson23
DJ_Jamba 2,822 Super User 2025 Season 1 on at

Like (0)

Report
Re: Change fill colour when date past

No that is the correct colour based on the condition:
DateDiff(Today(), DataCardValue14.SelectedDate,TimeUnit.Months) >= 1, Color.Orange
Anything over 1 month will result in Orange as per your condition
DJ_Jamba 2,822 Super User 2025 Season 1 on at

Like (0)

Report

Re: Change fill colour when date past

It is working fine for me based on the scenario you posted.
Can you try it out in a new screen with just a date picker and apply the code on the Fill property of a text label?
See attached gif...

FillCondition.gif
Benson23 18 on at

Like (0)

Report

Re: Change fill colour when date past

in above app the orange should be white ,mh/sa review is one year plus date from mh/sa . thought show the context .
Benson23 18 on at

Like (0)

Report

Re: Change fill colour when date past

Hi @DJ_Jamba .
thank you for replying ,
have tried that formula previous , but still unable to default back to white ,
very confusing !
Verified answer

DJ_Jamba 2,822 Super User 2025 Season 1 on at

Like (1)

Report
Re: Change fill colour when date past

Hi @Benson23

Could you try:
If( DataCardValue14.SelectedDate < Today(), Color.Red, DateDiff(Today(), DataCardValue14.SelectedDate,TimeUnit.Months) >= 1, Color.Orange, Color.White )