How to remove time concatenated to 'Date' fields in Delimited destinations

While trying to write the date “September 30, 2021” in a delimited destination file, it appends the parsed date with a timestamp every time it exports the data into the output .csv file. I attempted to add a few expressions between the report model and destination file in my dataflow for that field and it still appends with the timestamp.

Can anyone please advise how to remove the time from the parsed date value in the actual .csv output file?

You can use the format option present in the layout builder properties window for delimited destination file. Here you can give the desired format type according to your need. Please view the screenshot for better understanding.
This option is also present when exporting data to a delimited destination file in Report Miner as well