How can I transfer the date formula?

[phoebe_90]

1.The date is yy/mm/dd, how can I transfer it into mm/dd/yy?

For example: Transfer 2024/05/31      to  05/31/2024

2.Is there have a chance to use tool transfer the date  yy/mm/dd into the expression of English letters？

For example: Transfer 2024/05/31      to   May 31th,2024

[sergejs_kutkovics · Accepted solution]

Hello, @phoebe_90.

Use these expressions in formula tool:

1. 

DateTimeFormat(DateTimeParse([Date (text)],'%Y/%m/%d'), '%D')

2.

DateTimeFormat(DateTimeParse([Date (text)],'%Y/%m/%d'), '%b %d, %Y')

[Megshipp]

If this is something you would need to do for a few different workflows, you could always create a macro that would do it for you for an easier option. That's what I did at least. I just put the macro in all my workflows and it changes any field that is in DateTime format into the date format I want. I used the Multi-field formula tool with the expression : DateTimeFormat(toString([_CurrentField_]), '%m/%d/%Y') 

But that might be a bit of overkill if you only need it here or there.