Hi!
I have a field for "Week Ending Date" and then I have individual fields for each date of that week.
I'd like those individual date fields to auto-populate the correct date when the "Week Ending Date" field is filled in.
Is that possible?
Thank you so much!
Yes, this is possible using a script.
Here's the basic code to do it (to be used as the calculation script for the field that needs to show the day before that date, for example):
var s = this.getField("WeekEndingDate").valueAsString;
if (s=="") event.value = "";
else {
var d = util.scand("mm/dd/yyyy", s);
d.setDate(d.getDate()-1);
event.value = util.printd("mm/dd/yyyy", d);
}Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
AdChoices