Calculate approximate birthdate based on current age
Posted on 2014-03-20
I have an Access 2010 database used to track information on animals that come into our shelter. I need a way to keep better track of their age. Currently we enter the age based on what age it was when it first came into contact with us. Because we very rarely ever know the birthdate, the age is approximate based on our best guess. The problem is that that age never changes no matter how long they've been here. This is especially problematic for our animals less than a year old. We have ages ranging from hours, days, weeks, months, to years. I created a table a long time ago that converts the age they select from the drop down into years. So when they choose 3 months it converts it into 0.25. I'm using the field with the 0.25 data to figure out the birthdate using [BirthDate] = DateAdd("yyyy", -[Age], Date) but it only works if the animals is older than 1, otherwise it sees the age as zero and just enters today's date for the birthdate. What do I need to change in order to make this work?