To calculate for employee work experieance

[alem]

Alem:
hi friends I tried many methods but it will increase or decrease three or four months. Please help me to get exact year and month .
thanks in advance.

[alem]

To calculate for employee work experieance

Hi Alem:
To calculate Employee work expereance in Ms-Access what shall I do b/c
I tried by the following formulas but I got three or four month difference I can't get exact service year and that will display also with decimal number. which is meaning less.

Service year: ((([diff])/30)/12)

a person emplyed in different organization, fist I calcualte Begin and End date of emploment date then I use the above formula.

Diff represents Begin date-End date
Please help me what shall I do

Thanks in advance.

[MMcCarthy]

Hi Alem

Not sure what it is exactly you are looking for but the following will give you the number of months that employee was on work experience.

DateDiff("m", [Begin date], [End date])

Mary

[Rabbit]

DateDiff("interval", Start Date, End Date)

"yyyy" for year
"m" for month
You'll have to do a check because DateDiff rounds off.

[MMcCarthy]

DateDiff("interval", Start Date, End Date)

"yyyy" for year
"m" for month
You'll have to do a check because DateDiff rounds off.

Alem

Please don't double post. I am merging this with your other thread here.

Mary

[developing]

you could try it with a query...on column with start date, one with end. third that calculates...

[alem]

To Calculate Employment date

Dear all (alem)

I have got Your answere thanks a lot but my problem is not soved yet.

let me explain again
an employee employeed more than 3 organization
Example in A company from 2/4/2004 to 3/8/2005
in B company from 5/10/2005 to 5/8/2006
in C company from10/11/2006 to now()

To calculate service year for the above employee

I used Service year: DateDiff("d",[MinOfBeginDate],(Now()))
Year: ((([Service year])/30)/12)
30 represents months
12 represents year

It displays number like 3.4897373 this that is difficalt to interpret

[MMcCarthy]

Alem, you clicked report instead of reply on your last post. I am including content below for others to see. Please be more careful.

Assuming a table Employees and a field empID then you could use the following to get the number of days. How do you want that represented?

SELECT empID, Sum(DateDiff("d", [Begin date], [End date]))
FROM Employees
GROUP BY empID;