Problems with Formula Don't give me anything.

I have a Choice field With DateR1, DateR2...... to R5
What I need, Find all documents by DateRx that al delayed with respect to the CutOff date and not have Earned Value.
On the View Table I have this Formula
let myFrom := 'From Date';
let myTo := 'CutOff';
switch number(Dates) do
case 1:
(select DOCUMENTS where 'EarnedValue' = null and DateR1 >= myFrom and DateR1 <= myTo)
case 2:
(select DOCUMENTS where 'EarnedValue' = null and DateR2 >= myFrom and DateR2 <= myTo)
case 3:
(select DOCUMENTS where 'EarnedValue' = null and DareR3 >= myFrom and DateR3 <= myTo)
case 4:
(select DOCUMENTS where 'EarnedValue' = null and DateR4 >= myFrom and DateR4 <= myTo)
case 5:
(select DOCUMENTS where 'EarnedValue' = null and DateR5 >= myFrom and DateR5 <= myTo)
end
The Formula don't work
5 replies
-
I have a Choice field With DateR1, DateR2...... to R5
If the choice field selections are what your wrote "DateR1" etc. Then that is not a date field.
-
Hi Fred Yes Dthe choice field is DateR1, DateR2......to DateR5
Now how can I do That ? If possible with Choice (dynamic)
-
Now how can I do That ? If possible with Choice (dynamic)
If the table that you link to has the date data you need then yes that would be better.
Content aside
- Status Answered
- 2 yrs agoTue, October 4, 2022 at 3:15 PM UTCLast active
- 5Replies
- 75Views
-
2
Following