Is there any way to convert invalid dates to Valid dates?
while Loading to SQL server i am having trouble with these dates below is the error
Only dates between January 1, 1753 and December 31, 9999 are accepted.
Below is the Data
Data In DF
+———+——+—————-+
| ID| ID2| Date|
+———+——+—————-+
| 1| 001 | 0204-01-01|
+———+——+—————-+
expected Output
+———+——+—————-+
| ID| ID2| Date|
+———+——+—————-+
| 1| 001 | 2024-01-01|
+———+——+—————-+