0

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

null
    • Fred
    • 1 yr ago
    • Reported - view

    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.

    • Rafael Sanchis
    • Rafael_Sanchis
    • 1 yr ago
    • Reported - view

    Hi Fred Yes Dthe choice field is DateR1, DateR2......to DateR5

    Now how can I do That ? If possible with Choice (dynamic)

    • Fred
    • 1 yr ago
    • Reported - view

    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.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      Fred Yes Fred the DateR1 to DateR5 they are in the same Table DOCUMENTS.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 1 yr ago
      • Reported - view

      Resolved 

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 5Replies
  • 75Views
  • 2 Following