Access/SQL query by current month 1

[bicit]

Hello all,
Fairly basic question, I'm sure..I am trying to create a SQL based query to return all records from the start of the current month only. This criteria below works great for returning a rolling 30 days....

>=(DateAdd("m",-1,Date()))

...but I always want it fixed from the start of the current month..for example, running the query today grabs stuff from Sept 7th on.
Any ideas?
Thanks.
------------------

 

[Blorf]

So you want only records with a date that is greater than or = to the current month?

Instead of the date add, try

>=datevalue(format(date(), "MM-01-YYYY"))

ChaZ

"When religion and politics ride in the same cart...the whirlwind follows."
Frank Herbert

 

[bicit]

That worked beautifully! Thanks.

 

[Blorf]

You are welcome. And may the force be with you.

ChaZ

"When religion and politics ride in the same cart...the whirlwind follows."
Frank Herbert