Subscription E-mail Configuration of Dates

• mbrady5

  SSCrazy

  Points: 2835

  More actions

  October 9, 2009 at 11:26 am

  #212027

  Hello,

  I have a report that I would like to send out every Monday morning with a recap of the prior week. I have a start date/ end date parameter in my report. What I would like to do is to figure out how to set the start and end date fields, so it will always query the prior 7 days?

  Thanks

• Ivan Donev

  SSC Eights!

  Points: 957

  More actions

  October 10, 2009 at 9:38 am

  #1064466

  Hi there,

  You can use for start date the following expression: DateAdd("d",-7,Today()) and for end date Today().

  Those expressions can be set as default values for both parameters in the report definition and when creating the subscription to use default values.

  /ivan