Hi,
do you need to compare only dates or both dates and times?
An option would be to compare DateSerial and TimeSerial for SQL Server date and VBA date.
Luiz Cláudio Cosenza Vieira da Rocha - http://msmvps.com/blogs/officedev - IT Lab www.itlab.com.br