Obtaining a Year value from date

[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

 

[Allen Browne]

Use Year()

If the year should always be the same as that of the date, you must not
store it in a separate field. Instead, use a query with a calculated field
to get your year column.

More information:
Calculated fields
at:
http://members.iinet.net.au/~allenbrowne/casu-14.html

 

[fredg]

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

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

Or..

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