I have two tables as described below.
One called RecentDataPull which is imported with all text fields. If I import with a date/time or change to a different format, I get errors.
Another table with emails that is formated as date/time fields when the email was sent. Needs to be date/time so I can do calculations.
However when trying to do an update query, i get a conversion error. Anyone know anyway around this? I have tried datevalue and not sure its working properly.