How can I transfer the date formula?

Question

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 Answer

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')