Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to figure out the 2 simple formulas, but am drawing a blank. I
need to find the total number of years/month/days from a start date to and
end date. I need to have the yr.,mo.,day in one cell. Does anyone know the
formula to do that?
i.e. Hire date is 11/15/1999 ~ Present Date is 11/03/2005 What are the
number of years, months, day between these two dates?

Thanks!!!!!!!! If anyone can respond as soon as possible I would greatly
appreciate it!
 
I am trying to figure out the 2 simple formulas, but am drawing a blank. I
need to find the total number of years/month/days from a start date to and
end date. I need to have the yr.,mo.,day in one cell. Does anyone know the
formula to do that?
i.e. Hire date is 11/15/1999 ~ Present Date is 11/03/2005 What are the
number of years, months, day between these two dates?

Thanks!!!!!!!! If anyone can respond as soon as possible I would greatly
appreciate it!
Click to expand...

Check "A More Complete DateDiff Function" at
http://www.accessmvp.com/djsteele/Diff2Dates.html
 
See if this works for you:
have one column in your query to give you today's date
Date: Date()

Have another column
Length of Service: Diff2Dates("ymd",[HireDate],[Date])

But remember that the length of service calculation will change with the date.

If you want to calculate the difference between 2 static dates:
Length of Service: Diff2Dates("ymd",[MemberDate],[Service Reference date:
(MM/DD/YY)])
which will give you a pop up box to enter the service reference date.
 
thank you, i will try this.

Stephanie said:
See if this works for you:
have one column in your query to give you today's date
Date: Date()

Have another column
Length of Service: Diff2Dates("ymd",[HireDate],[Date])

But remember that the length of service calculation will change with the date.

If you want to calculate the difference between 2 static dates:
Length of Service: Diff2Dates("ymd",[MemberDate],[Service Reference date:
(MM/DD/YY)])
which will give you a pop up box to enter the service reference date.



Angel2679 said:
I am trying to figure out the 2 simple formulas, but am drawing a blank. I
need to find the total number of years/month/days from a start date to and
end date. I need to have the yr.,mo.,day in one cell. Does anyone know the
formula to do that?
i.e. Hire date is 11/15/1999 ~ Present Date is 11/03/2005 What are the
number of years, months, day between these two dates?

Thanks!!!!!!!! If anyone can respond as soon as possible I would greatly
appreciate it!
Click to expand...
Click to expand...
 
Back
Top