Calculate the birthdate of a 18 year old person

From SMTX Wiki
Jump to navigation Jump to search

Below is an example code to calculate the birthdate of a person that turns 18 today 

format('{0:yyyyMMdd}', DateAdd(ToDate('#REPLACE-FORMFIELD-FormName||TodayDateField||#'), -18, 'Y'))

Alternatively you can also use the Now function: 

format('{0:yyyyMMdd}', DateAdd(Now(), -18, 'Y'))
Retrieved from "https://wiki.smt-x.com/index.php?title=Calculate_the_birthdate_of_a_18_year_old_person&oldid=997"