Current Year expression in SSRS 2008
Hi,
Can anyone mention how to write expression within a Textbox, in order to fetch "CurrentYear" part of the date.
For ex, within textbox it should display "2010" as current year.
Thanks,
t
November 23rd, 2010 4:02pm
Hi T,
In the Value field, use the expression: = Now()
In the Number property, go to Custom, and use the format picture yyyy
Hope this helps.
--DanDJAnsc
Free Windows Admin Tool Kit Click here and download it now
November 23rd, 2010 4:10pm
Just to add...
you can use YEAR(NOW) AS well....Gaurav Gupta http://sqlservermsbiblog.blogspot.com/
November 23rd, 2010 7:54pm