current date comparison

[CountryGirl]

Hello,<br>I have a 9 0 date field that I am doing a query on and would like to compare it to current date.&nbsp;&nbsp;I keep getting an error because the fields are not the same size.&nbsp;&nbsp;Does anyone have any suggestions on how to fix this problem?<br><br>Thank-you!<br>

 

[MikeLacey]

Could you convert the two date values to strings before you do the comparison? <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>