Forum Discussion
NickProp28
Post Partisan
Post PartisanDATEFROMPARTS take 2 year raw data
Dear Community,
How can I modify this query to take raw data for two years?
DECLARE @StartDate Datetime;
SET @StartDate = DATEFROMPARTS(DATEPART(YEAR,GETDATE()-2),1,1)
WHERE
JS_SystemCreateTimeUTC > @StartDate
Appreciate any help provided!
DECLARE @StartDate Datetime;
SET @StartDate = DATEFROMPARTS(DATEPART(YEAR,GETDATE())-2,1,1)
select @StartDate
1 Reply
DECLARE @StartDate Datetime;
SET @StartDate = DATEFROMPARTS(DATEPART(YEAR,GETDATE())-2,1,1)
select @StartDate