Hello, we have a custom profile property named "DOB", and we have Dynamic Registration writing into that perfectly using the 3 dropdowns (day, month, year).

Hello Alex,

There are 2 different ways in which you can perform this validation:

* SQL Validation
* JavaScript (on Client Side Event)

It really depends on how you'd like to handle this validation, on the client side or server side. Client side is usually a more elegant solution for this type of validation.

I would recommend trying the following JavaScript function that I found on the web:

---------------------------------------
function getAge(dateString) {
var today = new Date();
var birthDate = new Date(dateString);
var age = today.getFullYear() - birthDate.getFullYear();
var m = today.getMonth() - birthDate.getMonth();
if (m < 0 || (m === 0 && today.getDate() < birthDate.getDate())) {
age--;
}
return age;
}
---------------------------------------

Add this function to Module Configuration -> Advanced Coding Options -> Custom JavaScript file -> JavaScript file.

Be sure to completely refresh your webpage after saving this function and exiting the admin configuration interface.


There are a couple things to note. If the validation fails, you'll probably want to inject informative text into a span or label using innerHTML , and you'd probably want to disable/hide the submit button until this validation is satisfied. If the validation passes, you'll want to clear the informative text in the span/label and display/enable the submit button.

Please let us know if you have any questions.

Thanks,

Ryan