Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
DECLARE @StartDate Datetime;
SET @StartDate = DATEFROMPARTS(DATEPART(YEAR,GETDATE())-2,1,1)
select @StartDate
DECLARE @StartDate Datetime;
SET @StartDate = DATEFROMPARTS(DATEPART(YEAR,GETDATE())-2,1,1)
select @StartDate