I need Your help, I try uses default date in SSRS.
I need date:
Last day previous month in previous year.
Last day current month in previous year.
I have to generate my reports witch change default date.
For Example:
DP1 First start date
=IIF(
Day(Today())-DAY(DateAdd("d",-(Day(today)-1), Today)) <=7,
DateAdd(DateInterval.Month, -13, DateSerial(Year(Date.Now), Month(Date.Now), 1)),
DateAdd(DateInterval.Month, -12, DateSerial(Year(Date.Now), Month(Date.Now), 1))
DK1 First finish date
=IIF(
Day(Today())-DAY(DateAdd("d",-(Day(today)-1), Today)) <=7,
Last day previous month in previous year
Last day current month in previous year
)
DP2 Second start date
=IIF(
Day(Today())-DAY(DateAdd("d",-(Day(today)-1), Today)) <=7,
DateAdd(DateInterval.Month, -1, DateSerial(Year(Date.Now), Month(Date.Now), 1)),
DateSerial(Year(Date.Now), Month(Date.Now), 1)
)
DK2 Second finish date
=IIF(
Day(Today())-DAY(DateAdd("d",-(Day(today)-1), Today)) <=7,
DateAdd("d", -1, DateSerial(Year(Today()), Month(Today()), 1)),
Today()
)

