Date remove 0

How To
1

Hi there,
my software is giving me a date in the form YYYY-MM-DD.
With a replace string I am able to change the English Month in a German one. That works too.
But here is the problem: I don’t want to have 01 for the day, I want only a 1 or not 02 but only 2.

So my idea was to use again the replace function (under tools)

{{replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(
1.Datum;
"01"; "1");
"02"; "2");
"03"; "3");
"04"; "4");
"05"; "5");
"06"; "6");
"07"; "7");
"08"; "8");
"09"; "9");
"January"; "Januar");
"February"; "Februar");
"March"; "März");
"May"; "Mai");
"June"; "Juni");
"July"; "Juli");
"October"; "Oktober");
"December"; "Dezember")}}

Unfortunately Make is deleting the “0” in front of the number after I saved the module.
After saving I can see only this

{{replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(1.Datum; 1; 1); 2; 2); 3; 3); 4; 4); 5; 5); 6; 6); 7; 7); 8; 8); 9; 9); "January"; "Januar"); "February"; "Februar"); "March"; "März"); "May"; "Mai"); "June"; "Juni"); "July"; "Juli"); "October"; "Oktober"); "December"; "Dezember"))}}

Maybe someone of you has an idea to fix this problem?

BEst
Christoph

2

Hey there,

you can use formatDate() to change DD to D, this should remove the zeros. But May ask what the incoming variable is exactly and why do you need to use replace the months? If its MM, then it should be a number and not a string in German.