Form Date Less 12 Months

[automationamateur]

I have a query whose date parameter comes from a form. The form has an 'end date' control to run a trailing twelve month report. I want the query to pull data between the end date on the form and twelve months prior. My criteria is below, the first part with the "-12" is not working. I don't want to use a start date on the form to get around this. Please advise. Thanks!

Between [Forms]![frmMarginBucketReportFilter]![EndDate]-12 And [Forms]![frmMarginBucketReportFilter]![EndDate]

 

[Joe4]

The formula, as you have written it, would only subtract 12 DAYS, not 12 MONTHS.

To do 12 months, use the DATEADD function, i.e.

Between DateAdd("m",-12,[Forms]![frmMarginBucketReportFilter]![EndDate]) And [Forms]![frmMarginBucketReportFilter]![EndDate]

 

[automationamateur]

Yes you are correct, I was drawing a blank today. Thanks!