Running tally of day from a start date and stop when there is a departure date

April 9, 20205 yr

Newbies

I am using Filemaker Pro Advanced to keep track of residence in our recovery program. We like to keep a running total of how many days they are here in our program and have it stop when they depart our program right now the calculation looks like this :

If(IsEmpty(Start Date) = 0; Get(CurrentDate)) - Start Date + 1

This was done by a previous employee but it doesn't stop the calculation when the leave. What I would like to do his to have it stop once the departure date field has a date in it but I am too new at all this to figure it out. Any one have a calculation out there for this type of script?

Thanks,

Sandi

April 9, 20205 yr

Something like:

Case(
  IsEmpty(Start Date) ; "" ;
  not isEmpty( Departure date ) ; Departure date - Start Date ;
  Get(CurrentDate) - Start Date + 1 )

Welcome to the forums!

April 9, 20205 yr

I believe it could be simply:

If ( DepartureDate ; DepartureDate ; Get ( CurrentDate ) ) - StartDate + 1

Set the result type to Number and make sure that the calculation is unstored and that the option "Do not evaluate if all referenced fields are empty" is selected.