• craig.jenkins - Tuesday, February 20, 2018 4:38 AM

    Guys, if i have a list of dates in a table how do i query how many of the dates are 5 years or older?

    Do you want five years ago today, or 1/1/five years ago? Is your date column actually a datetime column, in which case you might want to 'set' the time to 00:00.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.