SSRS - weekday name

Will F picture Will F · Dec 4, 2014 · Viewed 24.4k times · Source

any advice appreciated

I have as a column heading the expression =WeekdayName(weekday(fields!date.value))

This returns the day of the week, however, it is returning a day of the week one day in advance, eg when I put Monday's dates in the parameter it shows as 'Tuesday' in the report.

My question is can the above expression be tweaked to show the WeekdayName one day before, eg =WeekdayName(weekday(fields!date.value -1)) ? I tried this but got an error.

Thanks.

Answer

Mahesh picture Mahesh · Dec 4, 2014

So you want to subtract one day from the your incoming date then you can use the

  = DateAdd("d", -1, yourdateField)

This way you can subtract the any number of days from your date.

But did you try to see why it is giving the day of previous date. Do check the system date time or else check with the

 =WeekdayName(weekday(Today())) 

and see if it gives you the correct day of week for current date.