DateSerial Question

[DD]

Good Afternoon,

I have inherited an Access database and it contains the following
formula on a date field:

Between DateSerial(DatePart("yyyy",Date()),DatePart("m",Date())-2,1)
And Date()-(DatePart("d",Date()))

I believe this pulls data for the past two months, but I'm not clear on
how the entire functions works.

I would like to use the same formula and pull last 6 months of data,
can use the same formula but change the -2 to a -6?

Any information would be appreciated.

Thanks

 

[Ken Snell \(MVP\)]

Did you try making the change to -6? That should work for you. See
DateSerial function in Help file for more information about it.

 

[DD]

Thank you - that worked.