Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Angry Unanswered: Calculating a date difference yymm

    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??

  2. #2
    Join Date
    Sep 2003

    Think you can take it from there?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts