I have a field that is char(14) and I would like to write a query (for a view) that will return a datetime field that will be recognized by MS Access as a datetime field.
Here's a sample of the data in stored in SQL Server:
20041215163407
the field is named DeliveryTime
Can someone help with this?
TIA
Here's a sample of the data in stored in SQL Server:
20041215163407
the field is named DeliveryTime
Can someone help with this?
TIA