Ravi Kumar
Registered User.
- Local time
- Today, 12:07
- Joined
- Aug 22, 2019
- Messages
- 162
hello all,
I need to modify this to get the below result(I am not getting how to use of not null)
1. if due date is lesser than today's date or if completion date is empty then it should show overdue.
2. or if completion date is full then it should not show anything.
please help me.
Code:
=IIf(Int([Due Date])<Int(Date())&IsEmpty(Int([Completed Date]),"Overdue")
I need to modify this to get the below result(I am not getting how to use of not null)
1. if due date is lesser than today's date or if completion date is empty then it should show overdue.
2. or if completion date is full then it should not show anything.
please help me.