The SSRS WeekdayName function is a Date and Time function that will extract the Weekday from the given DateTime and return its name, starting from Sunday to Saturday, in string format. The syntax of the WeekdayName function to print the weekday’s name is as shown below.
=WeekdayName(DatePart("w", Fields!OrderDate.Value), True, 0)
=WeekdayName(2, True, 0)
From the above SSRS WeekdayName Function syntax, the first argument is the weekday number (1 = Sunday to 7 = Saturday). The boolean second argument (optional) accepts True (Mon, Tue, … Sun) and False (Monday, Tuesday, …, Sunday). The third argument (optional) is the first day of the week. Here, 0 means Sunday as the week start, 1 means Monday as the starting of the week. For instance,
=WeekdayName(2, True, 0) - Prints Mon on each row.
=WeekdayName(2, False, 0) - Whereas this expression Prints Monday on each row.
To demonstrate the SSRS WeekdayName function, we use the Employee table below, which has 15 records. The image shows the records in the Table report.
SSRS WeekdayName function Example
For this, let me add a new column to the Hire Date column’s right side and name it the Weekday Name. Next, right-click the textbox under Weekday Name and choose the Expression. To understand the report, I suggest you refer to the articles on charts, tables, grouping, and format tables in SSRS.
It opens the following expression window to print names of the Weekday. In the below expression, the Weekday function extracts the number (1 to 7) from the Hire Date column. Next, the SSRS WeekdayName function returns the name of the weekday for each employee HireDate column.
=WeekdayName(Weekday(Fields!HireDate.Value))
Similarly, add one more column (third argument) to demonstrate the power of the first day of the week and change the complete output. The code below considers the first day to be Monday.
=WeekdayName(Weekday(Fields!HireDate.Value), False, FirstDayOfWeek.Monday)
Please click the preview tab to see the report. For more functions >> Click Here!
