Number of Months

[tomk01]

I need to know how long an employee has worked at a company. I know the hire date. what is the right formula to produce only the number of months? I was thinking:

select (now - hiredate) as MonthsOfService

 

[SkipVought]

tomk01,

Try DateDiff Function

NbrMos = DateDiff("m", YourDate, Date())

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[tomk01]

great thank you

 

[MichaelRed]

but recognize that DateDiff returns the number of interval bioundaries traversed in the interval, So:

? DateDiff("m", #11/30/04#, #12/1/04#)
 1 


? DateDiff("m", #11/1/04#, #12/31/04#)
 1 
[code]

Which may (or may NOT) be suitable to the application.





MichaelRed

 

[SkipVought]

The most EXACT method is to calculate the number of DAYS, since a MONTH is ambiguous, You can convert days to months by the product of DAYS and ([12 mo per yr] / [365.25 days per yr])

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}