1 Reply Latest reply on Oct 27, 2010 9:39 AM by philmodjunk

    day counter working off of a date



      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.