Check if user is 18

[CapNcook]

Hi,

I need a little help from my use-case below.

I have a form that has a DOB(Date of birth) field and I want to check if the user is 18 if yes proceed with the usual workflow otherwise display an error message you must be 18.

Any guidance for this?

[ianGPT]

Hi,

One way I could think of is use combination of rules and calculation.

For calculated value you may use the following formula to check if user is already 18.

 

CASE 
  WHEN DATEDIFF(YEAR, [@field:DOB], GETDATE()) >= 18 THEN 1
  ELSE 0
END

If the user is already 18 it would return 1 else 0.


with this value we can now setup our rules.



Section 2 would be the container of our error message " You must be 18 "

as for the calculated field displaying 1 and 0 value you can hide it using simple CSS by following this article: https://howto.caspio.com/tech-tips-and-articles/how-to-hide-fields-in-datapages/

Hope this helps!

[Queso]

Hi @CapNcook,

Just to add, you can also try this other formula as well for getting the exact age in other scenarios like leap year date as feb 29:

FLOOR(DATEDIFF(YEAR,[@field:Start_Date],GetDate()) - 

(CASE WHEN DATEADD(YEAR,DATEDIFF(YEAR,[@field:Start_Date],GetDate()),

[@field:Start_Date]) > GetDate() 

THEN 1 

ELSE 0 

END ))