Obtaining a Year value from date

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hi,

I have a date field with values of MM/DD/YY. I want to
create a separate field called year which would only list
the year. Is there a way to obtain the year from a date
and place it in a separate field?

Thanks,

Chuck
 
Hi,

I have a date field with values of MM/DD/YY. I want to
create a separate field called year which would only list
the year. Is there a way to obtain the year from a date
and place it in a separate field?

Thanks,

Chuck
Click to expand...

To actually create a new column in a query, use:
YearOnly:Year([DateField])

Or..

YearOnly:Format([DateField],"yyyy")
 
Back
Top