Error in day name expression - days out of sync with dates

Paul,



Weekday can start on Sunday or Monday (usual), in fact you can set it to any day. That setting may also change with language setting. It has nothing to do with SSRS. It is SQL Server behaviour.



See demo below:

SET DATEFIRST 7;
SELECT @@DATEFIRST AS 'First Day'
    ,DATEPART(WEEKDAY, GETDATE()) AS 'WDpart'
    ,DATENAME(weekday, GETDATE()) AS 'Today'
GO  
/*
First Day                    WDpart     Today
7                       6       Friday
*/

SET DATEFIRST 1;
SELECT @@DATEFIRST AS 'First Day'
    ,DATEPART(WEEKDAY, GETDATE()) AS 'WDpart'
    ,DATENAME(weekday, GETDATE()) AS 'Today'
GO 
/*
First Day           WDpart      Today
1                       5       Friday
*/

---

Kalman Toth, SQL Server & BI Training, SSAS, SSIS, SSRS; http://www.SQLUSA.com