Answered

Switch function doesnt work with Today()

(1) Share

Report

Posted on by wuffwuff2003

Hi,

I will have a circle who is red or green or blue depending on the date. When I do an IF condition it works with <=Today() but in the switch condition it doesn't what do i do wrong here. This is my code:

Switch(ThisItem.Engin_date_fait; <= Today() +180 ; Red; = Today(); Green; <=Today() -10; Blue)

<=Today() is always red underlined ?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Cvetkovski7 30 on at

Like
a
(0)

Report
Copy link

Link copied!

"$" & If(
DatePicker1.SelectedDate = Today(),"3",
DatePicker1.SelectedDate = Today()+15,"5",
DatePicker1.SelectedDate = Today()+15,"32",
DatePicker1.SelectedDate = Today()+15,"123"
)

This is for Text,implement this in Color and change mu "number" with color name without ""

Was this reply helpful? Yes No
wuffwuff2003 33 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
I don't have date picker, i compare the TODAY() Date with a table element in sharepoint.
Thanks

Was this reply helpful? Yes No
Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Switch functions are for matching exact values, not for covering if something is within a range,

You can use the following:

If( ThisItem.Engin_date_fait <= (Today() +180) ; Red; ThisItem.Engin_date_fait = Today(); Green; ThisItem.Engin_date_fait <= (Today() -10); Blue )

Was this reply helpful? Yes No
wuffwuff2003 33 on at

Like
a
(1)

Report
Copy link

Link copied!

Ok thats the point, thanks that it is just matched values and not in ranges. Many thanks

Was this reply helpful? Yes No