First day of the month

[Angel_G]

Hi there.
I need to retrieve data in a query greater than or equal to11 months from
now() or date() but I need the criteria to default to the first day of the
month. I am trying

=DateAdd("m",-11,Date())

But it defaults to current date 11 months ago11/6/03 but I need 11/1/03
(which is the first day of the month 11 months ago)
Can any one give me some ideas?
Thank you.

 

[Brian Camire]

You might try:

=DateSerial(Year(Date()),Month(Date())-11,1)

 

[fredg]

Hi there.
I need to retrieve data in a query greater than or equal to11 months from
now() or date() but I need the criteria to default to the first day of the
month. I am trying
But it defaults to current date 11 months ago11/6/03 but I need 11/1/03
(which is the first day of the month 11 months ago)
Can any one give me some ideas?
Thank you.

11 months from today is 11 months in the future, but your DateAdd is
calling for 11 months in the past.
I'll assume you want from the previous 11 months.