This Week in Patriots History

[Zuma]

Such a minor thing and technically it is history (yesterday)...

 

[Ian]

Such a minor thing and technically it is history (yesterday)...

Ah, good call. I'll add a thing to exclude the current year.

 

[Zuma]

SELECT *
FROM YourTable
WHERE YourDateColumn < DATEADD(day, -365, GETDATE());

 

[Zuma]

FYI I roll in Dark mode. The Week in Patriots History is the only thing that stays in Light mode.

 

[Ian]

SELECT *
FROM YourTable
WHERE YourDateColumn < DATEADD(day, -365, GETDATE());

This one's a little more complex in terms of some of the paramaters, but that was essentially it, although a little more streamlined:
WHERE YEAR(YourDateColumn) < YEAR(CURDATE()).

 

[Zuma]

BTW speaking of Dark Mode...I think text signatures created in Light Mode are black in Dark Mode.

 

[Ian]

BTW speaking of Dark Mode...I think text signatures created in Light Mode are black in Dark Mode.

I'll have to look at it. Haven't had time over the last week or so, but hopefully I'll be able to finally get around to tweaking that.