Parameters

[luvtitans50]

I need to pass in 2 parameters @start and @end.

@start should always be - 1/1/current year
@end should always be - 12/31/current year

How can I achieve that?

Thanks,

 

[PDreyer]

declare @start datetime, @end datetime
select @start=dateadd(yy,datediff(yy,'',getdate()),'')
,@end=dateadd(dd,-1, dateadd(yy,datediff(yy,'',getdate())+1,''))
select @start, @end

 

[luvtitans50]

Thanks!! Have a wonderful day!!