Compile error - Year function

  • Thread starter Thread starter mnugent
  • Start date Start date
M

mnugent

I am getting a compile error message when I attempt to
extract the "year" from a date field. The formula I am
using is "yr: Year([date])". The [date] field is formated
as "Date/Time" in the table. Is there something wrong with
my installation or a bug in the code? - Mark
 
Thanks Duane. I reviewed Doug's page, but could not get
any of the references to come up "MISSING". Do you know if
Microsoft has identified any bugs with this portion of
Access? Should I reinstall Access? - Thanks again, Mark.
-----Original Message-----
You probably have a missing reference. Take a look at Doug Steele's page
http://members.rogers.com/douglas.j.steele/AccessReference Errors.html

--
Duane Hookom
MS Access MVP


I am getting a compile error message when I attempt to
extract the "year" from a date field. The formula I am
using is "yr: Year([date])". The [date] field is formated
as "Date/Time" in the table. Is there something wrong with
my installation or a bug in the code? - Mark
Click to expand...


.
Click to expand...
 
Is your [Date] field ever null? Is the field datatype Date/Time?

--
Duane Hookom
MS Access MVP


Thanks Duane. I reviewed Doug's page, but could not get
any of the references to come up "MISSING". Do you know if
Microsoft has identified any bugs with this portion of
Access? Should I reinstall Access? - Thanks again, Mark.
-----Original Message-----
You probably have a missing reference. Take a look at Doug Steele's page
http://members.rogers.com/douglas.j.steele/AccessReference Errors.html

--
Duane Hookom
MS Access MVP


I am getting a compile error message when I attempt to
extract the "year" from a date field. The formula I am
using is "yr: Year([date])". The [date] field is formated
as "Date/Time" in the table. Is there something wrong with
my installation or a bug in the code? - Mark
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top