360 vs 365 Day Years

  • Thread starter Thread starter Grace
  • Start date Start date
G

Grace

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?
 
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
 
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.
 
Back
Top