any help please!!!! On Wed, Oct 8, 2014 at 6:13 PM, Ranvir singh <[email protected]> wrote:
> 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)* > > >
