Year Fraction

G

grace

Excel has a function named yearfrac() which calculates
number of days between two dates. You can specify if you
want it to use a 360 or 365 day year. I would like to use
this in Access. Access help lists the function but it is
undefined when I attempt to use it in a query.
 
C

Cheryl Fischer

Yes, I have read the Help description on using DateDiff() and, more
important, used it frequently to determine the difference between two dates.
If you have a specific question about the use of DateDiff(), please post it
and I will try to assist.
 
A

Allen Browne

Would this be the same as:
DateDiff("d", [Date1], [Date2]) / 365

Or:
DateDiff("n", [Date1], [Date2]) / 525600
 
J

John Vinson

wazzup with plonk???
Click to expand...

"Plonk" is a Usenet term meaning "I have put you in my killfile so I
won't see any more of your lame, off topic posts".

Bong, it appears that you think microsoft.public.access is a chat
room. It isn't. It's a technical support newsgroup for users of the
database program, Microsoft Access(TM). If you're looking for chats,
flirtation, or the like, please look elsewhere; if you want help with
your database development, this is the right place and Cheryl is one
of the experts.
 
B

bong

Thank you for that clarification.i can't access to the site you
gave.anyway,can you give me another site address
 
J

John Vinson

Thank you for that clarification.i can't access to the site you
gave.anyway,can you give me another site address
Click to expand...

The site in my .sig isn't a casual chat room either. It's a different
technical support forum for Access.
 
Top