How to write the following sql function in SSRS expression

Question

Is there any equal function to

datepart(dw,getdate()) in SSRS expression which gives me the week number of a particular day

ie for monday it should be 2 .

Thanks in adavance

Answer 1

The date in VB is zero-based, so just convert the DayOfWeek enum to its integer value and add one...

CInt(DateTime.Today.DayOfWeek)+1