Date Comparison Script

Question

I have multiple date fields, ie:

Date.0

Date.1

…

Date.5

Date.6

These are formatted mm/dd/yyyy

In the custom validation script, after Date.0, I use the following to get the current number of the date field:

var str = event.target.name;

var res = str.charAt(str.length-1);

I then use this.getField("0." + (res-1)).value to compare against event.value.

What want to do is:

Compare the two dates to determine if the date just entered pre-dates the preceding date.
And, if it does, serve up: app.alert("The date you entered is invalid. Please enter a date that does not pre-date the previous entry date." ,0);

I would very much appreciate help in getting a working script.

Thank you

Thom Parker · Accepted Answer

Date comparisons in JavaScript are easy, as long as you can correctly parse the date. If the format you've specified is consistent, then it's even easier.

Here's an example:

var strDate1 = "2/11/2019";
var strDate2 = "2/12/2019";
// Create the actual date objects
var date1 = new Date(strDate1);
var date2 = new Date(strDate2);
// Do the comparison
if(date2 > date1)
  app.alert("Date 2 is later than date 1");

Very simple

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.