I have an excel datasource(Using Extract) where Date field is string, It is returning NULL for some Months with both DATEPARSE and DATE Conversion. Attached is the worksheet for reference
3 answers
There are only 30 days in the ninth month (September), so we can't convert 9/31.
Dan
