DATE CONVERSION PROBLEM

[oiciadteam]

Hi I am facing problem to convert the the below date format to normal date format on dd-mm-yy. I have already tried using the date conversion tool and datetimeparse formula but no luck

[marcusblackhill]

Hey @oiciadteam !

Use datetime tool and select custom. Use the expression dd-Mon.-yyyy

Hope that help!

[oiciadteam · Accepted solution]

Hi Thanks it worked 

[marcusblackhill]

Nice @oiciadteam !

Happy to help! Please mark that answer like accepted to close the issue.

Have a good developments!

[HomesickSurfer]

Hi @oiciadteam 

I like to use the below formula:

ToDate(datetimeparse([DATE],"%d-%b-%Y"))

Hope it works for you.