Transform dates

[echildm]

Hello everybody i have the following problem, i exported monetary indicators data from different sources and i have 3 different formats on the date field:

Format 1:  MMM/YY  Example: Jul/21

Format 2: DD/MMM/YY  Example: 01/Jul/21

Format 3 (Favorite one): DD/MM/YY  Goal: 01/07/21

¿How can I transform the formats 1 and 2  to the format 3 (DD/MM/YY)?

In the case of the format 1 i would like the day to be the first of each month, for example transform Jul/21 to 01/07/21.

Thanks in advance.

[BrunPierre · Accepted solution]

Format 1: Date(Date#(DateField,'MMM/YY'),'DD/MM/YY')
Format 2: Date(Date#(DateField,'DD/MMM/YY'),'DD/MM/YY')

[echildm]

It worked perfectly, thx for the help.