WHERE invoicedate BETWEEN

DATEADD( mm, -6, CAST( CAST( DATEADD( dd, 1-DAY( getdate()), getdate() ) AS CHAR( 11 ) ) AS DATETIME ) )

AND

CAST( CAST( DATEADD( dd, 1-DAY( getdate()), getdate() ) AS CHAR( 11 ) ) AS DATETIME )

Although I would recommend running GETDATE() one time prior to running this statement and using it in the statement as a constant.

Edited by - mromm on 05/02/2003 3:41:14 PM