Year Fraction

  • Thread starter Thread starter grace
  • Start date Start date
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.
 
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.
 
Would this be the same as:
DateDiff("d", [Date1], [Date2]) / 365

Or:
DateDiff("n", [Date1], [Date2]) / 525600
 
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.
 
Thank you for that clarification.i can't access to the site you
gave.anyway,can you give me another site address
 
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.
 
Back
Top