Convert to Date Format dd/MM/YYYY

[Roseline007]

Hi All,

I'm trying to convert this string 01-JUL-24 to this date format 01/07/2024.

Has anyone come across this before and how were you able to successfully convert it?

Thanks and I look forward to your responses.

[ShankerV · Accepted solution]

Hi @Roseline007 

As the output is also string format (not in ISO date format)

This can be achieved with the help of Formula tool.

Formula:

DateTimeFormat(DateTimeParse([Field1],"%d-%b-%y"),"%d/%m/%Y")

Many thanks

Shanker V

[cjaneczko]

You can use the following in a formula but it will still be a string. The proper datetimeformat in Alterx is YYYY-MM-DD.

datetimeformat(DateTimeParse([Field1],'%d-%b-%y'),'%d/%m/%Y')

[Roseline007]

Thank you so much! Works like a charm!