previous month

[travismp]

I searched but could not find a simple answer.

I want to see all results from last month for [TestDate]

Month(Date())-1) ? ? ? ? ? ? ?

 

[travismp]

I found this on a microsft page

Year([TestDate])*12+DatePart("m",[TestDate])=Year(Date())*12+DatePart("m",Date())-1

that is a beast. Does anyone have something better? If not this will work. I just thought I saw something much more simple a couple years back. Thanks.

 

[Jon K]

Alternatively, you can use this criteria for the [TestDate] field:-

Between DateSerial(Year(Date()), Month(Date()) - 1, 1) And DateSerial(Year(Date()), Month(Date()), 0)


That is, between the first day and the last day of the previous month.
.

 

[raskew]

Hi -

Try this as the criteria for your date field:

Between DateSerial(Year(Date()),Month(Date())-1,1) And DateSerial(Year(Date()),Month(Date()),0)

HTH - Bob