Teri Bridges
Member
- Local time
- Today, 02:46
- Joined
- Feb 21, 2022
- Messages
- 187
Hi folks, I am trying to write a multiple-expression but do not know how to connect them properly. Help is appreciated.
=IIf(not IsNull( [CompleteDate] , "Complete", " ", IIf(IsNull( [ReviewDate] , "Not Started)," ", IIF( [DueDate] > Day(), "Inprocess","OverDue")))
=IIf(not IsNull( [CompleteDate] , "Complete", " ", IIf(IsNull( [ReviewDate] , "Not Started)," ", IIF( [DueDate] > Day(), "Inprocess","OverDue")))