Mar 22, 2023 07:30 PM
Hello!
I'm hoping you guys can help. I'm a total newb with formulas.
I'm trying to build a animal shelter manager and usually we don't have the exact date of birth. Just an approximate age (ie, 2 years, 5 months, 4 days, etc.). Is there a formula that can calculate an approximate date from those numbers?
I've looked everywhere and tried a million different formulas.
Solved! Go to Solution.
Mar 28, 2023 11:31 PM
I see, thanks! We'll need to create a "Created Time" field to log the date the form was submitted so that we have a starting point, then we can use a formula field like so:
DATEADD(
DATEADD(
DATEADD(
Created,
-Days,
'days'
),
-Months,
'months'
),
-Years,
'years'
)
Mar 23, 2023 01:13 AM
Hm depends on how your data's set up really, could you provide a screenshot of your data now?
Mar 28, 2023 09:57 AM
Yes! Here is how I have it set up so far:
This is from Shelterluv, an animal shelter management system. When intaking the animal, it will ask the age in years, months, and days and then it will calculate the estimated birthdate.
Mar 28, 2023 11:31 PM
I see, thanks! We'll need to create a "Created Time" field to log the date the form was submitted so that we have a starting point, then we can use a formula field like so:
DATEADD(
DATEADD(
DATEADD(
Created,
-Days,
'days'
),
-Months,
'months'
),
-Years,
'years'
)
Mar 29, 2023 07:19 AM
You, my friend, are an absolute genius! Thank you so much! That is exactly what I needed!