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

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

DJ_Jamba 2,837 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Benson23

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

Was this reply helpful? Yes No
Benson23 18 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Benson23 18 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
DJ_Jamba 2,837 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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...

Was this reply helpful? Yes No
DJ_Jamba 2,837 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Benson23 18 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
DJ_Jamba 2,837 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

No probs and glad it's solved!
d(-_-)b

Was this reply helpful? Yes No