Post reply

Weekday name in SSRS - minor tweak

  • December 4, 2014 at 1:23 am

    #312837

    Any advice appreciated please

    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.

  • December 4, 2014 at 3:24 am

    #1762642

    Hi, give dateadd a whirl: http://msdn.microsoft.com/en-us/library/hcxe65wz%28v=vs.90%29.aspx

    Should be something along the lines of =WeekdayName(weekday(DateAdd(DateInterval.Day, -1, fields!date.value)))

  • December 4, 2014 at 4:04 am

    #1762654

    Worked perfectly - thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply