Home Forums SQL Server 2005 SQL Server Newbies Report subscription with Sysdate as default Parameter RE: Report subscription with Sysdate as default Parameter
mtassin
SSC-Insane
Points: 23099
More actions
June 25, 2008 at 7:50 am
#833968
Are you using stored procedures?
Try something like this if you are
create procedure showdate
@inputdate datetime = '01/01/9999'
as
if @inputdate = '01/01/9999' set @inputdate = getdate()
select @inputdate