CDate returning #Error (1 Viewer)

[David Ball]

Hi,

I use CDate() in a query calculated field to convert text to date format.

The problem is that for records that don't have a date it returns #Error.

Then my report crashes when I sort by date.

Is there a way to use CDate and not get the #Error?

Thanks very much

Dave

 

[Galaxiom]

=iif(isdate([field], CDate([field]), Null)