AnsweredAssumed Answered

Calculate the difference between the start date and end date, with a twist

Question asked by annep on Nov 7, 2017
Latest reply on Nov 11, 2017 by fmDATA

For the database I am working on, I need to know the length of time a child has been in foster care.  I have the fields Date Entered and Date Exited, and need to know the length of time between the two in years, months, and days. If the Date Exited field is empty, however, I want the calculation to use the current date.  Also, if the Exit Date is used for the calculation, I'd love for the font to turn to red, but that's a bonus. Thank you.

Outcomes