Did you try the snippet I send you earlier?
It is good to know that our export feature does indeed not export the way you have setup your column.
The date published column is always exported as the WP_Post returns the date.
The ACF Date column should always export in ‘Y-m-d’.
The snippet above will remove the time from the date in your export for the ‘Date Published’ column. I don’t understand why the ACF date is not correct in your Excell sheet. Just to be sure, can you check the raw CSV file and see if the date is also in the wrong format? Maybe the date is being corrected when opening the file in Excel.
And do you not have any custom hooks in your website related to our export feature?