DatePart function

[KyBoy1976]

I'm trying to utilize the "DatePart" function to populate a field in my table
to only show the "Year" of my incident which is filled in using a form.

I currently have a "Recieved_Date" field that is filled in using a form, and
I want the DatePart to take only the year from that information.

Year: DatePart("yyyy",[Recieved_Date])

that function gives me an error, and I'm not certain why.

 

[Stuart McCall]

I'm trying to utilize the "DatePart" function to populate a field in my
table
to only show the "Year" of my incident which is filled in using a form.

I currently have a "Recieved_Date" field that is filled in using a form,
and
I want the DatePart to take only the year from that information.

Year: DatePart("yyyy",[Recieved_Date])

that function gives me an error, and I'm not certain why.

The word 'Year' is reserved in Access (its the name of a built-in function.
Try calling it RecvDate instead.

 

[Douglas J. Steele]

What's the error?

One thing you need do is rename your alias: Year is a reserved word, and you
shouldn't use reserved words for your own purposes. For a comprehensive list
of names to avoid (as well as a link to a free utility to check your
application for compliance), check what Allen Browne has at
http://www.allenbrowne.com/AppIssueBadWord.html

 

[KyBoy1976]

TY for the responses, i realize "year" is a reserved word, and I could have
worded my issue a bit better.

My actual field in my table to be populated is YR_Made, access tells you
that year is a reserved word and shouldn't be used.

However, the datepart function still does not function as i need it to.

What's the error?

One thing you need do is rename your alias: Year is a reserved word, and you
shouldn't use reserved words for your own purposes. For a comprehensive list
of names to avoid (as well as a link to a free utility to check your
application for compliance), check what Allen Browne has at
http://www.allenbrowne.com/AppIssueBadWord.html

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I'm trying to utilize the "DatePart" function to populate a field in my
table
to only show the "Year" of my incident which is filled in using a form.

I currently have a "Recieved_Date" field that is filled in using a form,
and
I want the DatePart to take only the year from that information.

Year: DatePart("yyyy",[Recieved_Date])

that function gives me an error, and I'm not certain why.

.

 

[KARL DEWEY]

I think you will find that DatePart removes any time fraction leaving only
the DatePart.

Try Year([YR_Made])

--
Build a little, test a little.

TY for the responses, i realize "year" is a reserved word, and I could have
worded my issue a bit better.

My actual field in my table to be populated is YR_Made, access tells you
that year is a reserved word and shouldn't be used.

However, the datepart function still does not function as i need it to.

What's the error?

One thing you need do is rename your alias: Year is a reserved word, and you
shouldn't use reserved words for your own purposes. For a comprehensive list
of names to avoid (as well as a link to a free utility to check your
application for compliance), check what Allen Browne has at
http://www.allenbrowne.com/AppIssueBadWord.html

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I'm trying to utilize the "DatePart" function to populate a field in my
table
to only show the "Year" of my incident which is filled in using a form.

I currently have a "Recieved_Date" field that is filled in using a form,
and
I want the DatePart to take only the year from that information.

Year: DatePart("yyyy",[Recieved_Date])

that function gives me an error, and I'm not certain why.

.