I have fields named "When will item be returned?" and "Date Returned". The "When will item be returned?" field is chosen by the initiator when the item is created. The "Date Returned" field is set when the material has been confirmed returned.
Now if the material has not been returned by "When will item be returned?", then I want an e-mail to be sent to the initiator, and another member, stating that it has not been returned and to ask where it is at.
I can't seem to figure out how to do this. I've tried setting a condition within my workflow involving "When will item be returned?" and "Date Returned", but since the date returned field is always empty until it has in fact been returned, I don't think I can use it with my condition.
If anyone has any idea what I am talking about, any kind of help would be appreciated. I feel like I'm running around in circles trying to make this work.
Thank you!