By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
June 3, 2021 11:53 am
=IIF([SOOrder.RequestDate]<=Today(),'red0',IIF(SOOrder.RequestDate]<=(Today()+3),'yellow','default')).
In short I'm trying to change sales orders due same day or past due to red, within 3 days to yellow. I'm a novice and don't know what I'm doing wrong.
Can I add to the today() function? And does that add 1 day to the date format?
Can I use the addition operator in nested if statements?
How can I effectively code the request date within 3 days of today's date condition?
Help is appreciated, thanks in advance!
2 Replies
June 3, 2021 1:12 pm
Hi @tra_user,
Give this a shot:
=SWITCH([SOOrder.RequestDate]<=Today(),'red0',Datediff('d',Today(),[SOOrder.RequestDate])<=3,'yellow','default')
June 3, 2021 1:20 pm
@wyatt-erp That worked! I was getting close, was already working with the switch and datediff functions. Thank you!