| | |
|
|
|
Year Fraction |
|---|
| message from grace on 28 May 2004 |
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.
|
| Cheryl Fischer replied to grace on 28 May 2004 |
Have you tried using the DateDiff() function in Access?
|
| Cheryl Fischer replied to Cheryl Fischer on 28 May 2004 |
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.
|
| Cheryl Fischer replied to Cheryl Fischer on 28 May 2004 |
PLONK!
|
| John Vinson replied to Cheryl Fischer on 28 May 2004 |
"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.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
| John Vinson replied to John Vinson on 29 May 2004 |
The site in my .sig isn't a casual chat room either. It's a different
technical support forum for Access.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
| Allen Browne replied to grace on 28 May 2004 |
DateDiff("d", [Date1], [Date2]) / 365
Or:
DateDiff("n", [Date1], [Date2]) / 525600
|
|
Archived message: Year Fraction (MS Access Database)
