I am looking at running a report which will look at records added over the last 6 months. The date field is named [DateCreated] and I will be running the report on the first day of every month.
Does anyone know of any SQL that will automatically calculate the last 6 months?
asked Mar 22 '10 at 02:29 PM in Default
for a report parameter for the end of the report you could use this as the parameter default value to get the last day of prev month
To get the start date, 6 months prior to today, use the function supplied by Kev
answered Mar 22 '10 at 02:42 PM
or do you need a better definition of 'month'?
answered Mar 22 '10 at 02:33 PM
Kev Riley ♦♦