I'm trying to write a formula within Access to calculate the length of service, at the minute I've got it to display in years but can't work out how to get it to display years & months
The formula I currently have is:-
13/08/99 - start date, is bringing back the value 4 rather than 4 years 1 month
I've just found out that the Int rounds down to the nearest integer - any ideas as to how I can calculate the diff in yy mm??