Covert US date format to UK format

[Kuha]

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

From	To
2011/01/27	27/01/2011
2011/12/27	27/12/2011
2022/04/29	29/04/2022
2023/09/15	15/09/2023

[Luke_C · Accepted solution]

Hi @Kuha 

Here's how using the date functions:

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

[gaoa · Accepted solution]

Hi @Kuha 

using DateTime tool:

[Kuha]

Hi @Luke_C / @gaoa 

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