You'll need a calculation field to get that result. A number of threads here show this type of result for an age calculation.
Though if you define a "month" as always 30 days in length, the calculation is much simpler.
Thanks, but that was not my question. I know how to make a calculation that outputs a formatted text string in months and days. I am wondering if this is possible to do as a mask over a given field. I want the field to hold a number value of the age in days, but want the field to only display the value in months and days, if possible.
The problem with using a calculation is the value becomes "2m 15d" instead of a searchable value of 75, and this prevents searching for a range of ages, such as finding all animals that are between 30-60 days of age. The point here is to have the field's functions be in days, but have it simply display in the more readable formatting of months and days. Is this possible?
It is not possible. That's why I posted that you would need to use a calculation to get this result.
The problem with using a calculation is the value becomes "2m 15d" instead of a searchable value of 75,
But having one calculation field that returns the value in months and days does not keep you from also keeping the original calculation field that computes the age strictly in days so you can still search with ranges in inequalities as long as you search on the original calculation field not the new one.
Sounds good. I'll do this and have the field simply show and hide conditionally when in find or browse modes.