| | |
|
|
|
360 vs 365 Day Years |
|---|
| message from Grace on 28 May 2004 |
Excel has a function named YearFrac() which I would like
to use in Access. It is listed in the Access help,
however, when I include it in a query it says it is not
defined. Can this function be used in Access?
|
| Douglas J. Steele replied to Grace on 28 May 2004 |
Since the VBA help file is shared among various applications, it sometimes
is incorrect about whether or not a particular function can be used.
Now, you posted this same question earlier today, and you got a couple of
answers regarding workarounds that will work in Access. Did you not see
those responses?
If for some reason you're intent on using the Excel function, check out
http://support.microsoft.com/?id=198571
|
| Grace replied to Douglas J. Steele on 1 Jun 2004 |
I did not see the replies because I was looking for my
post based on time and date. Guess the date is some time
zone other than eastern since it shows up as posted before
I was even out of bed that day.
applications, it sometimes
can be used.
got a couple of
Did you not see
function, check out
|
|
Archived message: 360 vs 365 Day Years (Microsoft Access)
