Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 08, 2020 09:52 AM
How would I calculate days in foster care from the intake date to today but have it stop counting once the animal’s status is adopted? Ive got the intake date and adopted date but wasnt sure how the formula should be worded.
an example of the info
Solved! Go to Solution.
Nov 09, 2020 04:28 AM
Hi @Jessi_Burns!
Are there any other Status options besides “Available” and “Adopted”?
If not, then I think you’re looking for a formula like this:
IF(Status = "Adopted" ,DATETIME_DIFF({Adopted},{Intake}, 'days'), DATETIME_DIFF(TODAY(),{Intake}, 'days'))
This will count the number of days between Intake and Adopted if the Status is “Adopted”. Otherwise it will count the number of days from Intake to today. If there are other status possibilities then this might need to be tweaked slightly.
Hope that helps.
Nov 09, 2020 04:28 AM
Hi @Jessi_Burns!
Are there any other Status options besides “Available” and “Adopted”?
If not, then I think you’re looking for a formula like this:
IF(Status = "Adopted" ,DATETIME_DIFF({Adopted},{Intake}, 'days'), DATETIME_DIFF(TODAY(),{Intake}, 'days'))
This will count the number of days between Intake and Adopted if the Status is “Adopted”. Otherwise it will count the number of days from Intake to today. If there are other status possibilities then this might need to be tweaked slightly.
Hope that helps.
Nov 09, 2020 05:36 AM
Yeah there’s quite a few, around 13. Really only Available, Hold, Pending, and Adopted need the date, the rest either don’t apply or wouldn’t have both dates anyway.
Nov 09, 2020 10:32 AM
Would there be a way to exclude certain statuses?