Depends on how you want to do it - and we can;t see your screen, so we can't tell!
In C# code:
DateTime now = DateTime.Now;
if (release_date <= now && now <= remove_date)
{
...
But in SQL:
SELECT * FROM MyTable WHERE GETDATE() BETWEEN release_date AND remove_date