day counter working off of a date
Okay I want to count the number of days that contract is under evaluation. I know I need to go off of some date fields.
I know I can take the date_received - current_date to give me a number of days.
However I want it to give me the total days open if the evaluation was complete. I know for this I would need date_closed - date_received.
Where I am stuck is how to write it so if the date_closed is empty it will work off of the current_date - date_received and if date_closed has a date in the field it will do date_closed - date_received.