Calculat Days

  • Thread starter Thread starter QQ
  • Start date Start date
Q

QQ

I'm using the function is :

Working Days: Diff2Dates("ymd",[EmploymentDate Join],Date()+1,True)

But this function calculat is wong ?? Why ??

This formula from :

First copy the function into a module.
Save the module (with a different name than Diff2Dates)

Call the function in code or in SQL just as you would use any other
function.
The website and the function both document the usage.

This function does not do working days, but then I don't see how you could
do
working days and translate that into years and months anyway.

For instance, in a query.

SELECT Diff2Dates("ymd",[Join Date],Date(),True) as MembershipLength
FROM [Your Table]
Please Help Me !! Thank You!!!
 
QQ said:
I'm using the function is :

Working Days: Diff2Dates("ymd",[EmploymentDate Join],Date()+1,True)

But this function calculat is wong ?? Why ??

This formula from :

First copy the function into a module.
Save the module (with a different name than Diff2Dates)

Call the function in code or in SQL just as you would use any other
function.
The website and the function both document the usage.

This function does not do working days, but then I don't see how you
could do
working days and translate that into years and months anyway.

For instance, in a query.

SELECT Diff2Dates("ymd",[Join Date],Date(),True) as MembershipLength
FROM [Your Table]
Please Help Me !! Thank You!!!
Click to expand...

In what way is the calculation wrong? What does it give you, and what
did you expect it to give you?
 
Back
Top