For a column where years and months are entered as
1.02 for one year and two months, or
3.04 meaning three years and four months, how is that converted to a date?
Or just expressed so that it's base 10 correctly. Exactness preferred but not required.
Ideally, just convert to a date: ie, 3 years and four months (ago/from) todays date. Adding and subtracting dates is fairly straightforward, but these aren't exactly correct.
The fraction is base twelve, but of course it's seen as base ten.
Can the fraction simply be "marked" as base twelve?