Ross
Ross

Reputation: 3

SSRS Date question using Globals!ExecutionTime

Hi I am trying to print a report in SSRS with two dates in the header. the first date will be dated one week ago and the second will be todays date..

I can't seem to figure out how to get the date for one week ago working.. I have tried

**Globals!ExecutionTime - 7** 

as the expression but it does not work. any ideas?

Upvotes: 0

Views: 1575

Answers (1)

HardCode
HardCode

Reputation: 6765

=DateAdd("d", -7, Globals!ExecutionTime)

Upvotes: 1

Related Questions