SQLSearcher
asked on
SSRS Have the day of the week on your report
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
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
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for your help.
Did you check with the System Date Time settings?
The code you are using will work.
Open in new window