current year

[slimjen1]

All, using access 2010. How do I display the default value of a date/time field to just the current year instead of using =date() to get the full date.

 

[pr2-eugin]

How about

=Year(Date())

 

[slimjen1]

did this first and for some reason; it gives me 7/05/1905. I expected 8/20/2013?? If I change the field to Number it gives me the year as I want.

 

[slimjen1]

I used the format to get the year; yyyy but why does it give me 1905? Do I need to use serial in front and how because =year(serial(date())) gives me an error.

 

[slimjen1]

Got it. I had to use date() and format yyyy. Gets me 2013.