vba date comparison

I have 开发者_开发百科an access table where dates are stored in the format "25102010". How can I compare this to today's date? Thanks.

This will give you todays date formatted as you have above

Format(Date, "ddmmyyyy")