I have imported a date field in the form of dd/mm/yyyy which i formatted through excel to yyyy-dd-mm.

However this only affects the display and does not actually change the input to the same format.

How can I have the input converted to this format as I need to export it in csv which only takes the input and does not carry the formatting.