topic Re: Transform dates in Connectivity & Data Prep

Transform dates

echildm — Tue, 11 Jul 2023 21:39:25 GMT

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.

Re: Transform dates

BrunPierre — Tue, 11 Jul 2023 23:13:43 GMT

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

Re: Transform dates

echildm — Wed, 12 Jul 2023 13:22:55 GMT

It worked perfectly, thx for the help.