Change one date format to another.

[kamil.cyprian]

In the date1 field, I have a date in ddmmyyyy format. In the date2 field, I want to display a date from the date1 field in the d. m. yyyy format. How to do it?

[try67 · Accepted solution]

You can use this code as the custom calculation script of "date2":

var s1 = this.getField("date1").valueAsString;
if (s1=="") event.value = "";
else {
    var d1 = util.scand("ddmmyyyy", s1);
    event.value = util.printd("d.m.yyyy", d1);
}

[Imogen5E9C]

Oh my goodness, brilliant. Thanks so much.

[kamil.cyprian]

Super! It works perfectly!