Passing a date in from an API call to select rows ...

[Antonia_Lavende]

It’s pretty simple, but I’m new to this. I need a column that changes the age with the date of birth. So I know I have a columnn called AGE which should change when the child reaches a birthday in a roster. Any help so I can copy and paste a formula would be appreciated.

Thank you!

[Martin_Stegmark]

DATETIME_DIFF(TODAY(),{Birthday},'Year')

This formula outputs the age in years. You must have a field called Birthday where you have registered each persons birthdate.

Hope it helps.

//Martin

[Antonia_Lavende]

Thank you! That works!!

Antonia Lavender
310.803.6854
Antonia@AntoniaLavender.com