How to check if the current date/time is within a certain time range

I have three data fields in my database: CurrentDate, StartDate, EndDate
I need to see if the current date is within the start date and end date (preferably in the code behind, on page load)
Any help would be appreciated :)