changing date format when saving to .csv

Question

I want my date to be in "YYYY/MM/DD" format. In the alteryx, I am converting the field to string(yyyy-mm-dd) using date parse and then replacing '-'  with '/'.Even though it is in string format, when i open the output file, it automatically changes to it's own format. How do i avoid it.

binu_acs · Answer

@Kavya132017 If you try to open the .csv file in a notepad you will see the original format.

Kavya132017 · Answer

@binu_acs , when i open the output .csv file it is automatically showing date as per my system's date format

binu_acs · Answer

@Kavya132017 Can you try with DateTimeFormat([Date],'%Y/%m%d')