J
Jock W
I have a text field in a db linked to Access which I use for 'date new' data
for machines.
I can work out how old a machine is by:
=Left((Date()-CDate([um_gfld1]))/365,5) A bit messy! This will return, for
example, 15.24 (years) which, isn't exactly what I would like. Also, if the
result is less than 10 years, I get three decimal places (formatting the no.
of decimal places to 2 doesn't have any effect for some reason)
How can I display a result showing years, months and days?
for machines.
I can work out how old a machine is by:
=Left((Date()-CDate([um_gfld1]))/365,5) A bit messy! This will return, for
example, 15.24 (years) which, isn't exactly what I would like. Also, if the
result is less than 10 years, I get three decimal places (formatting the no.
of decimal places to 2 doesn't have any effect for some reason)
How can I display a result showing years, months and days?