B BoroLee Registered User. Local time Today, 20:57 Joined Aug 30, 2000 Messages 90 Oct 9, 2002 #1 I have a database which has start dates off all employees in it. i need to work out the number of years and months between this date, and today's date. Any help gratefully accepted. Thanks, Lee.
I have a database which has start dates off all employees in it. i need to work out the number of years and months between this date, and today's date. Any help gratefully accepted. Thanks, Lee.
Fuga Registered User. Local time Today, 21:57 Joined Feb 28, 2002 Messages 566 Oct 9, 2002 #2 Check out the datediff function. Fuga.
R raskew AWF VIP Local time Today, 14:57 Joined Jun 2, 2001 Messages 2,734 Oct 11, 2002 #3 Something like (from the debug window): myOld = #4/1/93# ? int(datediff("m", myOld, date())/12) & ":" & format(datediff("m", myOld, date()) mod 12, "00") 9:06
Something like (from the debug window): myOld = #4/1/93# ? int(datediff("m", myOld, date())/12) & ":" & format(datediff("m", myOld, date()) mod 12, "00") 9:06
