This web site runs on voting. Please indicate all helpful answers by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate this by clicking on the check mark next to that answer.
asked
Date within the last 5 years
Hi! I'm trying to show data with transaction date within the last 5 years. The following isn't working even when I select the column converted to datetime. TRANSACTION_DATE
TRANSACTION_DATE >= DATEADD(year, -5, GETDATE())
if you want from 1st Jan 5 years ago DATEADD(year, DATEDIFF(year, 0, GETDATE()) - 5, 0) if you want 5 years ago today DATEADD(YEAR, -5, DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0))
17 People are following this question.
