Date format change from YYYY-MM-DD to DD-MM-YYYY

[munipavankumar]

Hi Team,

I have a date format like YYYY-MM-DD with a Date Datatype. But I need it like DD-MM-YYYY format only with Date Datatype. I have achieved it using Formula Tool. The problem is, it is in String format but when I convert it to Date, the values are showing null. I have attached sample screenshot for your reference. Can anyone please help on this. Many more thanks. 

[Qiu]

@munipavankumar 

The Date format in Alteryx is YYYY-MM-DD.
If you force a string which is not "YYYY-MM-DD" format, it will thow a warning and get null value eventually.

[munipavankumar]

Yes, @Qiu Thanks for your response. my problem is the same. But I need to that DD-MM-YYYY format with Date data type. How we can achieve that.

[Qiu]

@munipavankumar 
I am sorry but you can not do that with Alteryx.