CDate function errors

[ppete]

Hi,

I think there may be a very simple solution to this but I've done a bit of searching on the forum and haven't come up with anything similar. So...

I'm using the Cdate function in a query:

nCloseDate: CDate(Right([ClosedDate],2) & "/" & Mid([ClosedDate],6,2) & "/" & Left([ClosedDate],4))

...but somewhere on the table the data isn't formatted correctly. Is there a way to search for errors?

thanks,

P