Can someone give me the SQL needed to filter by a date range in a "where" clause?
I am looking for something like this:
where EffectiveDate between <<a>> and <<b>>
In this example, I want <<a>> to be the first day of the month 6 months prior to the current date (today this would be 4/1/2011) and I want <<b>> to be the last day of the month 6 months in the future (today this would be 3/31/2012).
<<a>> and <<b>> should be 1 full year apart (i.e. 4/1/2011 - 3/31/2012).