So I'm working on a gallery to read from an excel file. The idea is that when get a weekend day in the gallery, the "TemplateFill" turns grey with the following code.
<If(DayOfTheWeek.Text = "Saturday" || DayOfTheWeek.Text = "Sunday" , RGBA(100,100,100,100))/>
The issue is that this code is working for Saturdays, but not for Sundays.
However this code works fine:
<If( DayOfTheWeek.Text = "Saturday" || DayOfTheWeek.Text = "Friday" , RGBA(100,100,100,100))/>
<If( DayOfTheWeek.Text = "Saturday" || DayOfTheWeek.Text = "Monday" , RGBA(100,100,100,100))/>
If this makes any sense...
Can anyone help?
Hi @Anonymous
It is possible that you have an extra space in the Sunday text. Try
If(DayOfTheWeek.Text = "Saturday" || Trim(DayOfTheWeek.Text) = "Sunday" , RGBA(100,100,100,100))
If that takes care of it, you have found your problem.
I do not. I have erased that and edited several times.
User | Count |
---|---|
251 | |
251 | |
82 | |
45 | |
29 |
User | Count |
---|---|
343 | |
262 | |
129 | |
69 | |
57 |