Question

Your data has a column which should be treated as a date, but when you change the data type to date you see a lot of null values or obviously incorrect dates like 12/30/1899. What can you do next since the date conversion did not work

Answer 1

Answer: Set the form back to string, then try the features of date conversion such as DateParse and Date

Explanation:

About the Date. The parse method, parses the date representation string and returns the number of milliseconds as of 1 January 2021, 00:00:00 UTC or NaN if the string is unrecognized or includes illegal date values in certain cases (e.g. 2019-09-31). Usage is not recommended