Query with date criteria for this month only

[Ymesei]

Is there any way to create a query that automatically sets the criteria for a date field to only include date within the current month?

 

[DreewToo]

You can do this type of query:<br><br>SELECT Workorders.WorkorderID, Workorders.DateReceived<br>FROM Workorders<br>WHERE (((Format([DateReceived],&quot;myyyy&quot)=Month(Date()) & Year(Date())));<br><br>HTH,<br>Drew

 

[DreewToo]

Duh on my part...I guess it's reasonable to assume this would work fine too for the where clause...<br><br>WHERE (((Format([DateReceived],&quot;mmyyyy&quot)=Format(Date(),&quot;mmyyyy&quot));<br><br>D<br><br>

 

[Ymesei]

Thanks DreewToo.&nbsp;&nbsp;It worked like a charm.&nbsp;&nbsp;I appreciate it much.