YEARFRAC Function

[Guest]

Hello,
In Excel, there is YEARFRAC function which calculates the difference between
the two given dates in year, including all decimals, set by the user. I
tried to use the same function in Access query, but did not work. I want to
get to the decimal point. Is there any function that does the same work as
YEARFRAC?
Thanks,

 

[BruceM]

See Help for Date Diff

 

[Jeff Boyce]

Seong

If you must use the YEARFRAC function in Access, you can set a reference to
Excel and "borrow" the function from there.

Regards

Jeff Boyce
<Office/Access MVP>