Shared Dataset for SSRS - Data Defaults

If someone could provide some insight in to how to make this work, it would be greatly appreciated. It needs to be in the format of 27-July-2014.

---

Hi Ansonee,

According to your descripton, you want to get the current week and previous week using the format 27-July-2014.

In this case, you can use a expression below to get this value in the parameter, and then use this parameter in the shared dataset.

Current Week:=datepart("ww",today())&"-"&MonthName(month(today()))&"-"&Year(today())

Previous Week:=datepart("ww",DateAdd("d",-7,today()))&"-"&MonthName(month(today()))&"-"&Year(today())

Regards,

---

Charlie Liao

TechNet Community Support