Copy link to clipboard
Copied
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);
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);
}
Copy link to clipboard
Copied
I'm a beginner, so I'm not sure I'm using these methods correctly either
Copy link to clipboard
Copied
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);
}
Copy link to clipboard
Copied
Works like a charm, thanks!