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개
There are only 30 days in the ninth month (September), so we can't convert 9/31.
Dan