Form field calculation - adding 2 weeks from today's date

Forum|Forum|2 years ago
February 7, 2024
1 reply
1428 views

Hi there,
I'm looking to create a field that will autopopulate a date that is two weeks out from today's date. I've already created a field that autopopulates today's date.
In my form, the today's date field is named "Today", and the field that I require assistance with is named "Start Date". In other words, I would like the form's start date to always be 2 weeks from today's date.
Any support would be greatly appreciated!
Thanks 🙂

This topic has been closed for replies.

Correct answer Nesa Nurani

As 'Validate' script of "Today" field, use this: (set date format to whatever you need)

if (event.value == "")
 this.getField("Start Date").value = "";
else{
 var today = util.scand("mm/dd/yyyy", event.value);
 var startDate = new Date(today);
 startDate.setDate(today.getDate() + 14);
 this.getField("Start Date").value = util.printd("mm/dd/yyyy", startDate);}

Nesa Nurani

Correct answer

Community Expert

As 'Validate' script of "Today" field, use this: (set date format to whatever you need)

if (event.value == "")
 this.getField("Start Date").value = "";
else{
 var today = util.scand("mm/dd/yyyy", event.value);
 var startDate = new Date(today);
 startDate.setDate(today.getDate() + 14);
 this.getField("Start Date").value = util.printd("mm/dd/yyyy", startDate);}

J

jordanm14Author

Known Participant

Hi Nesa,

Thanks for the quick response! I added your suggested script to the 'properties' > 'validate' tab of the 'today' field, however the Start Date field is still not auto populating a date. Any ideas why this might be happening? Thanks!

J

jordanm14Author

Known Participant

It now seems to be working. Thanks again for your help!

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded