How to convert DD-Mon-YYYY(string format) to DD-Mon-YYYY(string format) in date format

Question

I am using data from Postgre DB where I have Date format: 2020-01-21 and I am expecting the output 21-Jan-2020 as a Date data type in alteryx.

I have tried the approach from the below link but I am getting Null as output.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Date-Formatting-dd-Mon-YYYY/td-p/409156

Error Message

ConvError: Formula (49): DATETIMEPARSE: Cannot convert "08-Dec-2019" to a date/time with format "%Y-%m-%d": Expected a number for Month: 'Dec-2019'

Output :

Can anyone help to resolve this asap?

JosephSerpis · Accepted Answer

Hi @jyotibarai Alteryx can only accept the format of a date as YYYY-MM-DD so that is why your output formula is not working. As I can see from your screenshot you have already formatted as DD-Mon-YYYY as a string field that is the only way Alteryx would be able to handle that date in that format being recognized  as a string field. If you need to perform any additional data time functions you would need to use the Visit column as that in the format Alteryx recognizes as a date format.

afv2688 · Accepted Answer

Hello @jyotibarai,

Are you looking for this? "DateTimeFormat([Field1],'%d-%b-%Y')"

This dates can only be format as String. To have them output as date they have always to be in yyyy-mm-dd format.

Regards