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
 - 3 yrs agoLast active
 - 5Replies
 - 83Views
 - 
    2
    Following
    
 
