Crow Canyon Software Forum

Please or Register to create posts and topics.

Auto fill column with age based on date of birth

#1 · July 17, 2023, 1:31 am

Hi All

I have a form with [Child 1 DOB] in one column and wish to auto populate the [Child 1 Age] column based on this data.

Google searches comes back with JSON suggestions or formulas but none are working.

Is this a custom action or is there another way?

#2 · July 17, 2023, 9:59 pm

I managed to get a formula working =ROUND(((TODAY()-[Child 1 DOB])/365.25),0)&" Years"

BUT it refuses to display on the form. I can add that column from Form Controls but when viewing the form it is missing