Hi All, For below query I want to add date function like last 90 days.. But im unable to add the date function
*select distinct V_Packages.Name from V_Packages left outer join v_Add_Remove_Programs on V_Packages.Name=v_Add_Remove_Programs.DisplayName0 where v_Add_Remove_Programs.DisplayName0 IS NULL AND V_Packages.Name NOT like '%\_T\_%' escape '\'* I have tried the below thing not worked any help!!!! *select distinct V_Packages.Name from V_Packages left outer join v_Add_Remove_Programs on V_Packages.Name=v_Add_Remove_Programs.DisplayName0 where v_Add_Remove_Programs.DisplayName0 IS NULL AND V_Packages.Name NOT like '%\_T\_%' escape '\'* *and* *V_Packages.Name in (Select DisplayName0 from v_Add_Remove_Programs where DATEDIFF (D, convert(datetime,V_add_remove_programs.InstallDate0,0),GETDATE())<=90)*
