wiredgecko
New Member
- Joined
- Dec 1, 2014
- Messages
- 43
i have two date fields and a "status" field. what i would like to do is create an IIF statement which will do the following:
if date field 1 is not blank and date field 2 is blank then on the "status" show "waiting" otherwise "complete"
any help will be appreciated.
thxs
if date field 1 is not blank and date field 2 is blank then on the "status" show "waiting" otherwise "complete"
any help will be appreciated.
thxs