Skip to main content
gf90424411
gf90424411
Participant
April 2, 2018
Answered

Auto populate dates of week

  • April 2, 2018
  • 2 replies
  • 795 views

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);

This topic has been closed for replies.
Correct answer try67

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);   
}

2 replies

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
April 2, 2018

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
gf90424411Author
Participant
April 2, 2018

Works like a charm, thanks!

gf90424411
gf90424411Author
Participant
April 2, 2018

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

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices