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() )