<div>
Hi,<br />
<br />
<i>Did you check with the System Date Time settings?</i><br />
<br />
The code you are using will work.<br />
<br />

<pre><code id="code-20-40729431-1"> =WeekdayName(weekday(Today())) </code></pre>
</div>


Hi,

Did you check with the System Date Time settings?

The code you are using will work.



 =WeekdayName(weekday(Today())) 

<div>
From what I remember about that function is that it uses the system first-day-of-week setting, if you don't specify the value. &nbsp;I haven't seen that function return and invalid value, but my first inclination is that you might want to try to pass that value explicitly.
</div>


From what I remember about that function is that it uses the system first-day-of-week setting, if you don't specify the value.  I haven't seen that function return and invalid value, but my first inclination is that you might want to try to pass that value explicitly.

<div>
<div class="content wysiwyg-content">
Hello Experts Exchange<br />
I want to be able to have the week day on my report, I found a bit of code on the web which is this.<br />
<br />
=WeekDayName ( WeekDay( Today() ) )<br />
<br />
When I run the report it says Saturday, but it is a Friday. &nbsp;<br />
<br />
How do I get the report to show the correct day?<br />
<br />
Regards<br />
<br />
SQLSearcher
</div>
</div>


Hello Experts Exchange
I want to be able to have the week day on my report, I found a bit of code on the web which is this.

=WeekDayName ( WeekDay( Today() ) )

When I run the report it says Saturday, but it is a Friday.  

How do I get the report to show the correct day?

Regards

SQLSearcher

SSRS Have the day of the week on your report

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.