Loading

SSRS -having 2 date paramaters different automatically

Matthew Rodwell

6y786SQL

Morning, i need to create a 2nd date paramter in SSRS which is 1 day less that parameter 1, so i can do a sql statement. I don't want to have to ask them to add the 2nd date. just the report to work it out. is this possbile.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vinay Talapaneni6y ago
declare @firstdate date = getdate()
declare @secondate date
set @secondate = dateadd(day,0,dateadd(day,-1,@firstdate))
select @secondate
Navaneeth Krishnan6y ago
declare @firstdate datetime = getdate()
declare @secondate datetime
set @secondate = (select (DATEADD(DAY, -1, @firstdate)))
select @secondate