Question
June 12, 2007 at 08:47 AM
paul.kimber

Decimal points in DateDiff Calculation

by paul.kimber . Updated 19 years, 4 months ago

Access 2007
I have set up a personnel database (not using ANY programming)and want to calulate the difference in YEARS between 2 dates. However it come out as a whole number – rounded up – but I need it more exact that that – i.e. to at least 2 decimal places. How can I do that without resulting to any programming.

This discussion is locked

All Comments