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

    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:-
    =Int((Date()-[DateHired])/365.25)

    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
    Location
    MI
    Posts
    3,713
    Months=DateDiff("m",Date,[DateHired])

    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
  •