I think you have an issue handling empty data strings so in this case you need to add a Derived Column to create a new column or replace the existing date column with a transformation that converts empty strings to NULL
or a default date.
For example :
iif(isNull({your_date_column}) || {your_date_column} == '', toDate('1900-01-01'), toDate({your_date_column}, 'yyyy-MM-dd'))