Date Formatting from yyyy-mm-dd to dd/mm/yyyy

Question

Hi,

I am trying to convert date format from yyyy-mm-dd to dd/mm/yyyy. I have checked several solutions from here but I have noticed all the solutions provided store the formatted date into string. where as I was this new date format to be dd/mm/yyyy in date data type. Because it need to sort it ascending. If in string format it wont sort correctly. Could someone please let me know if that is possible?

Kind Regards,

Restya

Qiu · Answer

@restya_raju 
I agree with @Bren_Spill2 , "dd/mm/yyyy." will be treated as String type Data and will cause Sorting issue.

Better to keep the "yyyy-mm-dd" data to remain the sorting and then drop it before output.

Bren_Spill2 · Answer

@restya_raju - I would suggest sorting on your date column which is in the yyyy-mm-dd format and drop it before the output.