calculation help between three dates
I am completely new to filemaker and learning as I go. I am trying to get to grips with a calculation between three sets of date. Basically, I have a UK arrival date and an adoption date, but would like a calculation to tell me the number of days in kennels, either to adoption date or current date, if the adoption field is empty. In other words I would like days in kennels to be either to the current date, or to the adoption date (if there is one)
I have tried the following but it isn't valid, and I can't work out why, though it could be that i did not understand the Is Valid function
If(IsValid(Adoption_Date); Get(Adoption_Date) - UK_Arrival_Date; Get(CurrentDate) - UK_Arrival_Date)
Can someone help please?
If ( IsEmpty ( Adoption_Date ) ; Get ( CurrentDate ) ; Adoption_Date ) - UK_Arrival_Date