You need to do a condition where Date >= FromDate and Date <= ToDate

DECLARE @Table TABLE (FromDate DATETIME, ToDate DATETIME, ResultDate DATETIME)

INSERT INTO @Table VALUES

('2012-01-01','2012-03-31','2011-12-31'),

('2012-04-01','2012-06-30','2012-03-31'),

('2012-07-01','2012-09-30','2012-06-30'),

('2012-10-01','2012-12-31','2012-09-30')

SELECT

ResultDate

FROM

@Table

WHERE

GETDATE() >= FromDate

AND

GETDATE() <= ToDate