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.