0

I wrote this SSRS expression to get the month name, it gives the month name in English, but I want to get the Local Time or specific culture month name.

How to solve in SSRS?

MonthName(Month(Today()))
Pondlife
  • 15,992
  • 6
  • 37
  • 51
enginocal
  • 309
  • 1
  • 5
  • 19
  • possible duplicate of [Convert Month Number to Month Name Function in SQL](http://stackoverflow.com/questions/185520/convert-month-number-to-month-name-function-in-sql) – abatishchev May 23 '12 at 14:09
  • 1
    Your question is very unclear: are you asking how to do this in Reporting Services, not in TSQL? If so, I suggest you remove the various SQL tags, because they are not relevant. Unless of course you want the database to work out the month name for you? – Pondlife May 23 '12 at 14:30
  • @Pondlife,yes i asking in reporting services,@abatishchev edited my tag,he added. – enginocal May 23 '12 at 14:38

2 Answers2

0

Use DATENAME.

See MSDN:

The return value depends on the language environment set by using SET LANGUAGE and by the Configure the default language Server Configuration Option of the login.

abatishchev
  • 98,240
  • 88
  • 296
  • 433
  • thanks @abatishchev,but ssrs doesnt allow datename expression in textbox expressions.it give to failure. – enginocal May 23 '12 at 14:12
0

Here is the example i used in my project , hope it helps you as well http://www.codeproject.com/Articles/33355/Localization-of-SSRS-Reports

bhupendra patel
  • 3,139
  • 1
  • 25
  • 29