Re:age validation
please help me in creating a formula text field that checks whether the candidate is 18yrs or older based on the dob field ------------------------------ vikas pasula -------------------------...
Forum Discussion
I use this formula to get the employee's current anniversary year.
Floor(ToDays(Today()-[Sigma Employment Date])/365.25)
----------------------------------------------------------------
var date DOB = [Your Date of Birth Field];
var number Age = Floor(ToDays(Today()-$DOB/365.25);
If(
$Age >= 18, "older",
"less than 18 years old"
)
------------------------------
Dwight Munson
------------------------------