Change date format from YYYY/DD/MM TIME to UK format DD/MM/YYYY

[nmahmood91]

Hello All 

I am new to Alteryx, currently trying to use the formula function with a datetimeparse formula to change the format of some dates. 

The first column of dates contains some dates as dd/mm/yyyy which are already in the format required, but some of the dates are in the format yyyy/dd/mm i.e. 2024-01-12. I would like to make all dates dd/mm/yyyy so the output is like 30/09/2024.

30/09/2024
30/09/2024
30/06/2024
2027-03-10
2024-01-12

A second column of dates I am working with has dates which look like the following:

2025-03-31 23:59:00
2027-06-30 23:59:00
2026-04-01 23:59:00
2024-09-30 23:59:00
2024-09-30 23:59:00
2024-06-30 23:59:00
2027-10-03 23:59:00
2024-12-01 23:59:00

I would like to make these dates appear as dd/mm/yyyy so the output is like above i.e. 30/09/2024.

I am using the following datetimeparse formula:

Datetimeformat(if isnull(DateTimeParse([Contract _End_Date],'%Y/%d/%m')) then DateTimeParse([Contract _End_Date],'%d/%m/%Y') else DateTimeParse([Contract _End_Date],'%m/%d/%Y %I:%M:%S %p')endif,'%d/%m/%Y')

[binu_acs · Accepted solution]

@nmahmood91 use the DateTimeFormat() function

[nmahmood91]

Hi Thank you for your quick reply, thank you the issue is fixed!

[binu_acs · Accepted solution]

@nmahmood91 for the first column of data I provided a different formula which is mentioned in the first formula tool