Multiple acceptable formats for a single date field

Question

Hi, I have a requirement to create a single form field that could accept multiple date formats and not throw an error. Example my date field should be able to accept mmm-dd-yyyy or mmm-yyyy or yyyy , a user should be allowed any of the formats and it should not throw an error. If there any script that I can use ?

try67 · Accepted Answer

How its displayed if some chooses to enter "mmm-yyyy" it should display "-mmm-yyyy" if someone enters "yyyy" it should display "--yyyy"

You can do it using this code as the field's custom Format script:

if (event.value) {
	var numHyphens = event.value.match(/-/g);
	numHyphens = (numHyphens==null) ? 0 : numHyphens.length;
	for (var i=numHyphens; i<2; i++) event.value = "-"+event.value;
}

try67 · Answer

Try this as the field's custom Validation script:

var acceptedFormats = ["mmm-dd-yyyy", "mmm-yyyy", "yyyy"];
if (event.value) {
	var accepted = false;
	for (var i in acceptedFormats) {
		if (util.scand(acceptedFormats[i], event.value)!=null) {
			accepted = true;
			break;
		}
	}
	if (!accepted) {
		app.alert("The entered value is not in one of the accepted formats and will be rejected.");
		event.rc = false;
	}
}

Edited: small mistake in the code fixed

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