Date Conversion Issue Ms Access To Sql Server

I'm creating a table B from an exisitng table A. In the table A I have a column ValDate which is varchar and contains Date. When I try to create the table B I have a function used

Solution 1:

since you have date data in a string field is very likely you have some value that is not valid against your expected date format.

copy the data in a sql server table and then perform check and validation of the content of the string field.

have a look to the function try_convert that can be helpful when checking the content of the string field containing the date values.

when bad data is ruled out you can apply again your formula with (hopefully) a different result. a better solution would be to create a separate field with appropriate datatype to store date values converted from the string field and apply your logic to that field.