two date fields, one can't be before another

Question

I need to make sure the End Date falls after the Start Date in my fillable pdf, can someone help with the script? Start Date: MM DD YYYEnd Date: MM DD YYY I have attached the pdf, thank you!!

try67 · Accepted Answer

You can use this code as the custom calculation script of a (hidden) text field:

var startDateMonth = this.getField("part3.month").valueAsString;
var startDateDay = this.getField("part3.day1").valueAsString;
var startDateYear = this.getField("part3.year").valueAsString;
var endDateMonth = this.getField("part3b.month").valueAsString;
var endDateDay = this.getField("part3b.day1").valueAsString;
var endDateYear = this.getField("part3b.year").valueAsString;

if (startDateMonth && startDateDay && startDateYear && endDateMonth && endDateDay && endDateYear) {
	var startDate = util.scand("mmm dd yyyy", startDateMonth + " " + startDateDay + " "+ startDateYear);
	var endDate = util.scand("mmm dd yyyy", endDateMonth + " " + endDateDay + " "+ endDateYear);
	if (startDate && endDate && startDate.getTime()>=endDate.getTime()) {
		app.alert("Error! The end date must be after the start date.");
		this.resetForm(["part3b.month", "part3b.day1", "part3b.year"]);
	}
}

try67 · Answer

This is a bit complicated to do with individual fields for month, day and year, as you would first need to validate that all the fields are filled-in, before merging them into a single string, then converting that string into a Date object and compared it with the Date object from the other field.

Can you combine them to a single field, you think?

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