Past dates excluding current month

[sdjames1979]

Hi guys

I have 'Next Service' dates in a table, I need to run a query showing all 'Next Service' dates that have expired (overdue), but not dates in the current month.

i,.e. If I run the report today, I only want to see August and before dates - even if there are some dates in September.

Thanks

S

 

[Galaxiom]

WHERE datefield < DateSerial(Year(Date()), Month(Date()), 1)

 

[sdjames1979]

You're a star!