question compare end date and start date in Community Central forum

compare end date and start date

Community Alums — Wed, 25 Sep 2024 13:14:48 GMT

Hello, I have a requirement for the Record Producer. There are two variables: "Proposed Effective Date" and "Expected End Date," both of which are of the "Date" type variable.

1)Requirement is that the "Expected End Date" must be greater than the "Proposed Effective Date." If this condition is not met:

Clear the value of "Expected End Date" whenever the "Proposed Effective Date" is changed.
Display the error message: "Expected End Date is smaller than Proposed Effective Date."

Re: compare end date and start date

brianlan25 — Wed, 25 Sep 2024 13:40:17 GMT

You have two option for the comparison of dates.

1. No Code Data compare UI Policy

2. Script Include with client scripts

As for Clearing Expected End Date you could try doing that in a client script but know that you cannot see the previous value to verify that it was actually changed.

Re: compare end date and start date

KrishnaSwaA — Wed, 25 Sep 2024 13:51:28 GMT

Hi @Community Alums

Create a script include:

Script Include name: DateTimeUtils

client callable: true

Script:

var DateTimeUtils = Class.create(); DateTimeUtils.prototype = Object.extendsObject(AbstractAjaxProcessor, { compareEndDate: function() { var check = false; var startDate = this.getParameter('sysparm_start_date'); var endDate = this.getParameter('sysparm_end_date'); var gdt1 = new GlideDateTime(startDate); var gdt2 = new GlideDateTime(endDate); check = gdt1.before(gdt2); return check; }, type: 'DateTimeUtils' });

2. Create a client script onchange of proposed effective date