Share via

Get month name in report

Jefferson-2765 586 Reputation points
2025-01-22T08:16:45.3+00:00

How to get current month name in SSRS report？For today i want to get the value like January

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,389 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,984 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 40,056 Reputation points
    2025-01-22T08:21:43.9866667+00:00

    Hi @Jefferson-2765，

    You may use monthname function in SSRS.

    Check below expression: 

    =MonthName(Month(today()))

    See SSRS MonthName Function

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.