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