Adding Days to Start Date ( Date Parameter) to get End Date-next week

shivam_p · 2017-08-01 08:38:30

I am using Date Paramer, I have input start date parameter as STDT, now, in my query, I am giving date to be in between ${STDT} and ${STDT +7} for a week ahead. How should I correct this- ${STDT +7}?

eduardo · 2017-08-01 09:05:55

Hi shivam_p,

you can use your db-standard ways of adding dates. For example, if you are using mysql, you could use DATE_ADD()

Regards,
Eduardo

shivam_p · 2017-08-01 09:08:14

Hii Eduardo, thanks for your reply. I am just trying the DATE_ADD(), How can i use ${STDT} in that?

eduardo · 2017-08-01 10:59:37

Hi shivam_p,

try with
DATE_ADD(${STDT}, INTERVAL 7 DAY)

Regards,
Eduardo

ReportServer Forum

#1 2017-08-01 08:38:30

Adding Days to Start Date ( Date Parameter) to get End Date-next week

#2 2017-08-01 09:05:55

Re: Adding Days to Start Date ( Date Parameter) to get End Date-next week

#3 2017-08-01 09:08:14

Re: Adding Days to Start Date ( Date Parameter) to get End Date-next week

#4 2017-08-01 10:59:37

Re: Adding Days to Start Date ( Date Parameter) to get End Date-next week

Board footer