AnsweredAssumed Answered

day counter working off of a date

Question asked by kilbot on Oct 27, 2010
Latest reply on Oct 27, 2010 by philmodjunk


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.