Hi,
Is there possible to calculate to validate DOB, i mean want to allow user enter data DOB Age 16 years up, if user enter DOB age below 16 years will error popup.
best regards,
Sophearom
Hi,
Is there possible to calculate to validate DOB, i mean want to allow user enter data DOB Age 16 years up, if user enter DOB age below 16 years will error popup.
best regards,
Sophearom
@sophearom, maybe you could do it as outlined in the image shared below:
Date constraint.xlsx (23.2 KB)
Dear Kal_Lam,
I have format DOB as text (type) because we want user to type in dd-mm-yyyy, it seems syntax provided not work. kindly have advise?
Try using the date
question type and that should solve your issue.
we don’t use date data type for field DOB, I mean we’re using DOB field text type to allow user enter quicker than using (date data type). I wondering if we use DOB field as text data type maybe have other solution can be done?
best regards,
sophearom
Hi Kal,
Sorry to bother you again. With above code, I am not able to get the desired result. My DOB should give me range of age only between 17 to 70 years. I have used the following code but of no use.
Requesting your inputs on this.
@Priyanka, maybe this workaround should solve your issue:
Date constraint.xlsx (23.4 KB)