Using date to determine value in a field

Question

Hi,I am wanting to create a script to select a particular value, based on date.Specifically, the selection will be based on the date occuring on or prior to 01/01/1996.  The date field is "DOB"  The field I want to autofill is named "CourseFee".  I have two calculated fields and want to be able to select and autofill the "CourseFee" field based on the date.If the date is prior to the one above, I want a value (Under25) to autofill.  If the date is later than the one above, I want the value (Over25) to autofill.Is this doable?

try67 · Answer

First of all, as mentioned, the age depends not only on the DOB, but also on the current time... But what you described can be achieved using the following code as the custom calculation script of "CourseFee":

var dobString = this.getField("DOB").valueAsString;
if (dobString=="") event.value = "";
else {
	var dob = util.scand("mm/dd/yyyy", dobString);
	var cutOffDate = new Date(1996, 0, 1);
	event.value = (dob.getTime()>=cutOffDate.getTime()) ? "Under25" : "Over25";
}

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