Extracting part of a date

I have a field called complete which is a date field, in the format of 02/12/2004 6.00PM, I want to extract the year from it.

How can I do this

Thanks

Poly
polynominalAsked:
Who is Participating?
 
TimCotteeConnect With a Mentor Head of Software ServicesCommented:
Hi polynominal,

Use

DatePart(year,MyDateField)

Tim Cottee
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.