Here is my command in SSRS 2008 to get the Month Name and Year.
THe result of my command should be like this, if current date is > 26 then the month name should display "Jan-2014" Else "Dec-2013'.
Why I am getting an error with this command in SSRS? I have problem with the first condition. thanks.
=IIF(Day(Now()) > 26,MonthName(Month(Now())+1,3)&"-"&Year(now()),MonthName(Month(Now()),3)&"-"&Year(now()))