Post reply

SSRS expression with DatePart to return "Day of Week"

  • April 28, 2009 at 10:26 am

    #204063

    I have seen the DatePart function used as : =DatePart("dw", MyDate.value) This returns #Error.

    My query uses set datefirst 5 (which I believe is Friday) to set the first day of the week. This does not seem to be working when I group by week.

    Is there another way in SSRS to set the first day of the week? And how in SSRS do I display the day of the week based on the mydate.value?

    Thanks.

  • April 28, 2009 at 11:28 am

    #985336

    Sorry. Please disregard. Better to handle in the query and then group on "week".

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

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