Spay/Neuter While In Care

[lizzadeth]

We’d like to run a report on spay/neuter between two dates of animals that have only been spayed/neutered while in care and not prior to intake. Sometimes we will intake animals from our municipal pound the same day they have had surgery so intake date and SN date are the same. I tried creating a custom field for “SN Prior To Intake” with yes, no, unknown as options but can’t figure out how to add a filter for this on any report so that any selected “yes” don’t show up. Is there a way to do this? Is there a better report I should be using that maybe I’m missing?

[bobintetley]

There's a report you can install called "Neutered in care" that shows this. It looks at the spay/neuter date field and compares it against intake and movement dates to determine whether the animal had the surgery in care.

The system assumes that if the animal has the spay/neuter checkbox ticked, but no date is set that the animal was already neutered/spayed before it entered your care.

You should therefore be able to do "Neutered=1 AND NeuteredDate Is Null" in your reports to identify animals neutered prior to intake, and "Neutered=1 AND NeuteredDate Is Not Null" to identify animals that were neutered/spayed in your care.

I will add criteria for "neutered/spayed in care" and "neutered/spayed prior to care" to the query builder to make it easier in future.

[lizzadeth]

Ok so if the spay/neuter date and intake date are the same we should just not put the date of spay/neuter in and it should leave those ones out.

I’ll give this a try! Thank you!!

[lizzadeth]

Seems to be working for us!!