• Thank Guys, i've attached some dummy data below.  As you can see the regdates are not older than 5 years

    -- Sample data
    IF OBJECT_ID('tempdb..#LOGFILE') IS NOT NULL DROP TABLE #LOGFILE
    SELECT * INTO #LOGFILE FROM (VALUES
    ('BAA', '2018-02-19 10:53:08.837','2016-03-31 00:00:00.000','123451'),
    ('BAA', '2018-02-19 10:53:08.837','2015-02-28 00:00:00.000','123452')

    ) d (Dealer, Created, Regdate, RegNo)

    SELECT DISTINCT * FROM #LOGFILE
    WHERE #LOGFILE.Dealer = 'BAA'--
    AND #LOGFILE.Created >='2018-02-19' AND #LOGFILE.Created <'2018-02-20'
    AND #LOGFILE.RegdATE > DATEADD (year, -5 , GETDATE() )