TMap how to add Year to date where it is not found

[Anonymous]

Hello,

I have a table that should contain a Date like "21-03-2018 17:38" for example, the problem is some dates dont include the year (for example "21-03- 17:38") I would like to, in TMap, check if the date has a year or not, and add it where it is not present.

Note1: the Day is also sometimes "1-03-2018 17:38", meaning that it should be "01" in order to be the same length as the rest of the results

Note2: the date is transformed beforehand in the TMap as well since it starts off as "6 June 2018 at 17:51" and I turn it into "6-06-2018 17:51"

[Anonymous]

Thank you guys both!, a well deserved Kudos