I am trying to convert the date from US format (yyyy-mm-dd) to UK format (dd-mm-yyyy). Any help please. FromTo2011/01/2727/01/20112011/12/2727/12/20112022/04/2929/04/20222023/09/1515/09/2023

Covert US date format to UK format

I am trying to convert the date from US format (yyyy-mm-dd) to UK format (dd-mm-yyyy). Any help please.

Here's how using the date functions:

DateTimeFormat(DateTimeParse([From],'%Y/%m/%d'),'%d/%m/%Y')

using DateTime tool:

Here's how using the date functions:

DateTimeFormat(DateTimeParse([From],'%Y/%m/%d'),'%d/%m/%Y')

using DateTime tool:

Both solutions worked fine. I think I had some glitches in the process. After I deleted the tools and tried again. No issues.

Thanks for your quick response.

Cheers

Kuha