Date Functions to get first three months of year or any 3 consecutive months

[stevekroll]

For a filter condition, I want to use the date function DatePart() to get only the records for the first three months of the year or any three consecutive months. I am not sure how to enter the date component(m, q) in the date DatePart function to achieve this.

Is this correct for first three months/first quarter?

DatePart ("q", [DatePlaced])=DatePart("q=1), Date()) set q=1 for first quarter?
and DatePart("yyyy" [DatePlaced])=DatePart("yyyy", Date())

Is this correct for any three consecutive months from today?

DatePart ("m", [DatePlaced])=DatePart("m=4,5,6", Date())


and DatePart("yyyy", [DatePlaced])=DatePart("yyyy", Date())

[orange]

Did you try It? What result?

[stevekroll]

I don't have Access at home. It will wait till tomorrow in the office. Just wanted to know if i was on the right track.

[orange]

You can find Access/vba functions and sample usage at TechOnTheNet