AnsweredAssumed Answered

Date calculation if end date is not always used

Question asked by Christian on Mar 14, 2013
Latest reply on Mar 15, 2013 by Christian

Title

Date calculation if end date is not always used

Post

     Hi Everyone,

     I am trying to calulate two date fields "Start Date" and "End Date".  I've been using

     Year ( Get (CurrentDate) ) -

     Year ( Start Date )
      
     to tell me how many years someone has been working with us.  Ideally, what I want to calculate is how many years and months someone has been working with us.  The "End Date" however, is not always a used field in cases where the employee is still working for us.
      
     How would I set up this calculation to calculate in Years and Months:
      
     Current Employee: how long they have been with us (End Date is blank)?
     Past Employee: how long they have been with us (End Date is filled out)?
      
     Thanks for your help!

Outcomes