AnsweredAssumed Answered

calculation help between three dates

Question asked by AnnaHaurer on Apr 5, 2014
Latest reply on Apr 6, 2014 by philmodjunk

Title

calculation help between three dates

Post

     Hi all, 

     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?

     Thank you

Outcomes