DateAdd()

[cbrsix]

I am trying to write this formal but I can't get it to work..



=DateAdd("yyyy",1,Format(Date(),"yyyy"))

What I am trying to accomplish is to have the report show next years date. For example, if the report is run today. I want the report to show yr 2012. Any ideas or suggestions?

[GrandMasterSexay]

try this...

=Format(DateAdd("yyyy",1,Date()),"yyyy")

[cbrsix]

That worked. Thanks.

[GrandMasterSexay]

Cheers mate....