CODEWITHSUNDEEP
reporting-services
satya
satya

Reputation: 373

SSRS Date Parameter default to last 30 days with Time

Please could someone help me in getting the below issue sorted?

I am looking for a default Date Parameter (Start Date) to be Last 30 days from Today along with the Time e.g 30 days from now is 24/05/2016 but would like to include Time as well 24/05/2016 07:00:00

I have an expression which only give me Last 30 days date Expression i have is =DateAdd("d",-29,Today())

Regards

Upvotes: 2

Views: 7681

Answers (2)

rchacko
rchacko

Reputation: 2139

SSRS Expression to get 30 days back from today using DateAdd function:

=DateAdd(DateInterval.Day, -30,Today())

Upvotes: 0

alejandro zuleta
alejandro zuleta

Reputation: 14108

Try:

=Now.AddDays(-30)

UPDATE: Default time

=Today.AddDays(-30).AddHours(7)

Let me know if this helps.

Upvotes: 5

Related Questions