Convert String to Date

[swenger]

I am linking with ODBC to another database where the dates are being stored as a string but with a time. Here is an example 2014-10-20 04:00:00



I would like to convert this to a short date. If i use Cdate() it works but the records which don't have anything come up as #Error

Whats the simplest way to deal with this. Ideally I would like to do this in the query as I have one query which reads this table and all my other queries and forms are based off this one query.

Thanks

Sam

[aytee111]

IIf(Not IsNull(datefield),CDate(datefield))

[swenger]

Thanks for your help