Case Function Syntax Error
Can someone help me to identify the syntax error in the following Case function? Case([calc Days Until Promise Dt], <Days(0),"Overdue", <=Days(2),"Due in 2 Days", <=Days(4),"Due in 4...
Forum Discussion
I did notice the missing comma, but I'm still getting the same syntax error. I've also tried the following without success:
Case([calc Days Until Promise Dt],
<0,"Overdue",
<=2,"Due in 2 Days",
<=4,"Due in 4 Days",
<=7,"Due in 7 Days",
>7,"Beyond 7 Days"
)
//Where[calc Days Until Promise Dt] is of type formula Duration
Case([calc Days Until Promise Dt],
<0,"Overdue",
<=2,"Due in 2 Days",
<=4,"Due in 4 Days",
<=7,"Due in 7 Days",
>7,"Beyond 7 Days"
)
//Where[calc Days Until Promise Dt] is of type formula Duration