Getting a field autofilled based on dates

Question

Hello,I have been trying to find a solution to the below issue for the last 3 days.I am creating a form. My skill level is beginner.I am using Adobe Pro DC.The form in question has a date filed calendar. User can also enter their own date (YYYY-MM-DD) or chose a date on the pop-up calendar.I have an other field which will contain a value (based on the date).If the date entered is between April 1, 2018 and March 31, 2019, the field will display "2018-19"If the date entered is between April 1, 2019 and March 31, 2020, the field will display "2019-20".ex: user enters the following date:Result:PR (is autogenerated based on the type of ticket - This is already working, I do not need assistance here)12345 (ticket number will be manually entered by the operator - I will probably just add an additional text field.)Thank you in advance for any help you might be able to provide.Valerie

try67 · Accepted Answer

OK, then you can use this code as the custom calculation script of the Ticket field:

(function() {
    var startDate1 = new Date(2018, 3, 1, 0, 0, 0, 0).getTime();
    var endDate1 = new Date(2019, 2, 31, 23, 59, 59, 999).getTime();
    var startDate2 = new Date(2019, 3, 1, 0, 0, 0, 0).getTime();
    var endDate2 = new Date(2020, 2, 31, 23, 59, 59, 999).getTime();
    event.value = "";
    var s = this.getField("DateOrigReq").valueAsString;
    if (s=="") return;
    var d = util.scand("yyyy-mm-dd", s);
    if (d==null) return;
    var v = d.getTime();
    if (v>=startDate1 && v<=endDate1) event.value = "2018-19";
    else if (v>=startDate2 && v<=endDate2) event.value = "2019-20";
})();

try67 · Answer

What if the date entered is not within those periods?

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