Forum Discussion

NickProp28's avatar
NickProp28
Icon for Post Partisan rankPost Partisan
3 years ago
Solved

DATEFROMPARTS 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_SystemCreateTi...
Need Help
  • VigneshSub's avatar
    VigneshSub
    3 years ago

    DECLARE @StartDate Datetime;
    SET @StartDate = DATEFROMPARTS(DATEPART(YEAR,GETDATE())-2,1,1)
    select @StartDate

     

VigneshSub's avatar
VigneshSub
New Member
3 years ago

DECLARE @StartDate Datetime;
SET @StartDate = DATEFROMPARTS(DATEPART(YEAR,GETDATE())-2,1,1)
select @StartDate