question Re: End date should not be more than 6 months from start date in Developer forum

End date should not be more than 6 months from start date

Lakshman12 — Wed, 22 Jul 2020 00:54:11 GMT

I am working on functionality as below

I have two fields on catalog item includes – start date and end date. We do not want users to select end date not more than 6 months from start date.

For example: start date = 07/22/2020

If End date = 1/22/2021 (technically difference is more than 180 days because of few months has 31 days ).

Let us say if end user selects 1/23/2021 as end date, then I should alert them saying not to select as it is more than 6 months calendar days.

I would really appreciate your help. @Pradeep Sharma @Ankur Bawiskar @Chuck Tomasi

Thanks

Lakshman

Re: End date should not be more than 6 months from start date

Naveen Sagar S1 — Wed, 22 Jul 2020 02:27:38 GMT

Hi Lakshman,

Client Script : onChange (end date)

function onChange(control, oldValue, newValue, isLoading) {

if (isLoading || newValue == '') {

return;

}

var ga = new GlideAjax('ScriptIncludeName');

ga.addParam('sysparm_name', 'addMonths');

ga.addParam('start_date', g_form.getValue('start_date'));

ga.addParam('months_to_add', 6);

ga.getXML(getEndDate);

}

function getEndDate(response) {

var answer = response.responseXML.documentElement.getAttribute("answer");

if (answer) {
if(g_form.getValue('end_date') > answer) {
alert("End date should be less than " + answer);
}

}
}

Script Include :

var ScriptIncludeName = Class.create();

ScriptIncludeName.prototype = Object.extendsObject(AbstractAjaxProcessor, {
addMonths: function() {

var start_date = this.getParameter('start_date');

var months = this.getParameter('months_to_add');
var gdt = new GlideDateTime(start_date);
gdt.addMonths(months);
return gdt.getDate();

},

}

This will solve your issue of 180 days.

Re: End date should not be more than 6 months from start date

Namrata Khabale — Wed, 22 Jul 2020 03:00:06 GMT

Hey Lakshman,

Check out this threads, it will help you:

https://community.servicenow.com/community?id=community_question&sys_id=6a54dedadb1fa340d6a102d5ca961978

https://community.servicenow.com/community?id=community_question&sys_id=62964f25db1cdbc01dcaf3231f96195f

https://community.servicenow.com/community?id=community_question&sys_id=4a640b69dbd8dbc01dcaf3231f9619d7

https://community.servicenow.com/community?id=community_question&sys_id=15658baddbd8dbc01dcaf3231f961936

Mark Correct and Helpful if it helps!!!

Best Regards,

Namrata.

Re: End date should not be more than 6 months from start date

Lakshman12 — Wed, 22 Jul 2020 04:14:56 GMT

Hi Naveen,

I am getting Null as return value from script include when I implemented yours.

Thanks

Lakshman

Re: End date should not be more than 6 months from start date

Mark Roethof — Wed, 22 Jul 2020 04:59:22 GMT

Hi there,

Have you considered using a (Catalog) UI Policy to achieve date validations? There's almost no-code needed to achieve date validations this way. Have a look at an article I wrote on this:
No Code date validations thru (Catalog) UI Policies

Scripting data validations is a poor choice and in most cases unnecessary.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

Re: End date should not be more than 6 months from start date

Indrajit — Wed, 22 Jul 2020 05:39:32 GMT

Hey Lakshman,

Check out this below similar thread it will help you,

https://community.servicenow.com/community?id=community_question&sys_id=409035e0dbcfb3c414d6fb2439961965

kindly mark Correct and Helpful if Applicable.

Regards,

Indrajit.

Re: End date should not be more than 6 months from start date

Arjun31 — Wed, 22 Jul 2020 05:53:07 GMT

Hello Lakshman ,

please paste this code in your onchange client script , no need to write server side script,

To check selected date is within future 6 month

var datesplit = (newValue+'').split('-');
var date= new Date(datesplit[2],datesplit[0]-1,datesplit[1]);

// for current date
var MaxStartDate = new Date();

// add six months in current date.
MaxStartDate.setDate(MaxStartDate.getDate() + 180);

if(date>MaxStartDate)
{

alert('selected date :'+date
+'Max date : '+sixmonthdate
+'Please select valid date');

}
else
{
alert('valid date');
}

Mark Correct and Helpful if it helps .

Best Regards,

Arjun Shinde

Re: End date should not be more than 6 months from start date

Megha Padale — Wed, 22 Jul 2020 05:56:12 GMT

Hi Lakshman,

Addition to Namrta, check this link

https://www.servicenowguru.com/scripting/client-scripts-scripting/client-side-dates-in-servicenow/

If my answer helped you in any way, mark answer as helpful and correct.

Thanks and regards,

Megha

Re: End date should not be more than 6 months from start date

Dhananjay Pawar — Wed, 22 Jul 2020 06:04:00 GMT

Hi Lakshman,

In addition to above, I will suggest you to try no code solution which will be best to keep system performance.

Create catalog ui policy as below and change variable names as per requirement.

Mark correct and helpful based on impact.

Thanks,

Dhananjay.

Re: End date should not be more than 6 months from start date

Naveen Sagar S1 — Wed, 22 Jul 2020 12:18:45 GMT

Apologies, my bad can you replace

start_date with sysparm_start_date
months_to_add with sysparm_months_to_add

in both the client script and script include. That should work fine.

Re: End date should not be more than 6 months from start date

Lakshman12 — Wed, 22 Jul 2020 12:43:55 GMT

Naveen,

Still the same issue -- getting Null from script include.

Re: End date should not be more than 6 months from start date

Lakshman12 — Wed, 22 Jul 2020 12:47:22 GMT

Arjun,

Thanks for sharing the script. I have already used the similar script but it is not including 31 first day of few months. for example from 7/22/2020 through 01/23/2021 -- there are 4 extra days, i.e means 184.

so, I am looking for something which can include extra days as well.

Thanks

Lakshman

Re: End date should not be more than 6 months from start date

Mark Roethof — Wed, 22 Jul 2020 12:56:46 GMT

Any luck on this? Any questions?

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

Re: End date should not be more than 6 months from start date

Naveen Sagar S1 — Wed, 22 Jul 2020 13:02:55 GMT

can you share the code because it is working fine for me with following code

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue == '') {
        return;
    }

    //Type appropriate comment here, and begin script below

    var ga = new GlideAjax('ScriptIncludeName');

    ga.addParam('sysparm_name', 'addMonths');

    ga.addParam('start_date', g_form.getValue('start_date'));

    ga.addParam('months_to_add', 6);

    ga.getXML(getEndDate);

}

function getEndDate(response) {

    var answer = response.responseXML.documentElement.getAttribute("answer");
	alert(answer);
    if (answer) {
        if (g_form.getValue('end_date') > answer) {
            alert("End date should be less than " + answer);
        }

    }

}

var ScriptIncludeName = Class.create();
ScriptIncludeName.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    addMonths: function() {

        var start_date = this.getParameter('start_date');
        var months = this.getParameter('months_to_add');
        var gdt = new GlideDateTime(start_date);
        gdt.addMonths(months);
        return gdt.getDate();

    },

    type: 'ScriptIncludeName'
});

Re: End date should not be more than 6 months from start date

Dhananjay Pawar — Wed, 22 Jul 2020 13:05:06 GMT

Hi Lakshman,

Did you get chance to work on my comment?

Thanks,

Dhananjay.

Re: End date should not be more than 6 months from start date

Arjun31 — Wed, 22 Jul 2020 13:58:59 GMT

Hello Lakshman,

Yes correct so you can replace

MaxStartDate.setDate(MaxStartDate.getDate() + 180); this line of code with

MaxStartDate.setMonth(MaxStartDate.getMonth() + 6);

you will get exact date you are looking for.

regards,

Arjun Shinde

Re: End date should not be more than 6 months from start date

Lakshman12 — Wed, 22 Jul 2020 15:30:48 GMT

Arjun,

here is what I have tried exactly as you mentioned but still not working.

var datesplit = (newValue + '').split('-');

alert(datesplit); // output when I select 01/23/2021 == 2021,01,23

var date = new Date(datesplit[2], datesplit[0] - 1, datesplit[1]);

alert("date : "+date); // output == date : Tue May 01 2091 00:00:00 GMT-0400 (Eastern Daylight Time) ---> which is 2091 (failed case), how can it be 2091 after spliting

var MaxStartDate = new Date();
MaxStartDate.setMonth(MaxStartDate.getMonth() + 6);

if (date > MaxStartDate) {
g_form.showFieldMsg('end_date', 'End Date should not be more than 6 months from start date', 'error');
g_form.clearValue('end_date');
} else {
g_form.hideFieldMsg('end_date');
}
}

Note: I am writing this script in HR scoped application, not sure if this method works in scoped app.

Re: End date should not be more than 6 months from start date

Lakshman12 — Wed, 22 Jul 2020 15:35:55 GMT

Hi Dhananjay,

Yes, I have tried exactly what you suggested and still is not working.

Thanks

Re: End date should not be more than 6 months from start date

Lakshman12 — Wed, 22 Jul 2020 15:43:27 GMT

Mark,

I have tried creating UI policy as suggested, but not working.

Note: I have written this in HR scoped application, not sure whether this matters.

Thanks

Lakshman

Re: End date should not be more than 6 months from start date

Lakshman12 — Wed, 22 Jul 2020 15:46:52 GMT

@asifnoor Checking if you can help me on this please.

Thanks

Lakshman