only want year to show in date field

[Mrunkowski]

release date of movies I only want the year to show , HOW?

 

[Tom van Stiphout]

On Mon, 28 Apr 2008 06:21:01 -0700, Mrunkowski <[email protected]>
wrote:

Use the Year function:
select Year(ReleaseDate) as YearOfReleaseDate
from SomeTable

-Tom.

 

[Douglas J. Steele]

What do you want to actually store: just the year, or the actual date of
release?

If you want to only store the year, use an Integer field as opposed to a
Date field.

If you want to store the actual date of release, but only display the year,
use a Date field, and set its Format to yyyy. (Note that if you do use a
Date, you must store a complete date in it.)