SELECT {SurveyForm}.[Title], CASE WHEN MONTH(GETDATE()) <=3 THEN MONTH({SurveyForm}.[DueDate]) IN(10,11) ELSE NULL END AS DueDate FROM {SurveyForm} Thanks
SELECT {SurveyForm}.[Title], CASE WHEN MONTH(GETDATE()) <=3 THEN (SELECT MONTH ({SurveyForm}.[DueDate]) FROM {SurveyForm} where MONTH ({SurveyForm}.[DueDate]) IN (10,11) ) ELSE NULL END AS DueDate FROM {SurveyForm}
SELECT {SurveyForm}.[Title],'' FROM {SurveyForm} where ({SurveyForm}.[DueDate] between DATEADD(qq, DATEDIFF(qq, 0, GETDATE()) - 1, 0) AND DATEADD(dd, -1, DATEADD(qq, DATEDIFF(qq, 0, GETDATE()), 0))) Thanks again.