changing date format when saving to .csv

[Kavya132017]

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. 

[binuacs]

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

[Kavya132017]

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

[binuacs]

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