Adding current Date (Just Year) to report

[bradleyg]

Hi and thanks for looking at my question. I have a simple question. In my report I want to add just a non bound label that will show just the year not the whole date. I added the label I went to control source clicked the expression builder, built in functions (date/time) and all I can figure out how to do is add the date() which give me the full date. SO.... what should I do to show the year only. Please give me the full format I am clueless :-)
I am asking this because I have 20 different reports that every year I have to go in and change the date i.e. 2013 master items, 2013 product guide, ect it would be great if I could just have it update itself every year. I am getting lazy
thanks
Brad

[ssanfu]

For an unbound text box, try

=Year(Date())



Warning: If you try to print a historical report (say the year 2010) with the line above, the report will still display the current year.

[bradleyg]

Steve it worked thank you very much!!!