Auto populate dates of week

[gf90424411]

I'm building a form which populates the date fields for Monday through Saturday from the Sunday field "WENDING". The following custom calculation script is for the Saturday date field, but shows a "SyntaxError: missing ) after argument list".

var dayMs = 86400000;

event.value = util.printd("mm/dd/yyyy", util.scand("mm/dd/yyyy, this.getField("WENDING").valueAsString).getTime() - dayMs);

[gf90424411]

I'm a beginner, so I'm not sure I'm using these methods correctly either

[try67 · Accepted solution]

Adding milliseconds is tricky because of things like the change to/from daylight savings time, which mess it up.

A better approach is to do it like this:

var sundayString = this.getField("WENDING").valueAsString;
if (sundayString=="") event.value = "";
else {
    var d = util.scand("mm/dd/yyyy", sundayString);
    d.setDate(d.getDate()+1);
    event.value = util.printd("mm/dd/yyyy", d);   
}

[gf90424411]

Works like a charm, thanks!