First of the previous month
- DateSerial(Year(Date), Month(Date) - 1, 1)
Last of the previous month
- DateSerial(Year(Date), Month(Date), 0)
You can use these formulas with the
Between operator in the criteria field for your date in the underlying query. Using it like this, you need to let Access know that
Date is a function, not a field, so you have to add the parentheses after it, like
Date(). The criteria would look like this:
- Between DateSerial(Year(Date()),Month(Date())-1,1) And DateSerial(Year(Date()),Month(Date()),0)
-
Linq
;0)>