Convert Date Format

[JDong]

Hi Team,

If we notice in the attached file, the 2021 date format is wrong. For 2020 we can see the date format to be in the DD.MM.YYYY but for 2021 it is MM.DD.YYYY

How can I change these values for 2021 only to show as DD.MM.YYYY. This also needs to be considered in future similar issues can happen in the data loads.

Thanks !

[Emil_Kos · Accepted solution]

Hi @JDong,

Propably there is a couple of options please see my solution below:

[JDong]

@Emil_Kos 

Thanks Is it possible without harcoding the year but convert where needed ?

[Emil_Kos · Accepted solution]

Hi @JDong,

You need to have some kind of identifier because this value 01.10.2021 can be two different months. 

In my opinion, you need to have some kind of identifiers to be sure that you are transforming the data correctly.