Formula for year

[Dana_Hiatt]

How do I create a formula to add only the year in primary column? I am using Datetime_Format (Date, ‘YYYY’)

[Jeremy_Oglesby]

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

That should get you what you want, and will always be up to date to TODAY().

[Dana_Hiatt]

Thank you. That give me his current age but I need to know the age at reach each event happened in his life. So one column has the date that the event occurred, one column has age and the other has his birthday. Do you know what I need to add to the formula to make that work? Thanks again - Dana

[Dana_Hiatt]

I figured it out.

Thank you,

Dana

[Jeremy_Oglesby]

For each one, replace TODAY() in the formula with a reference to the field that holds the Date of the event in question. So if you have a Field called “Married On” that has each person’s Marriage Date in it, then you could get the age of the person on their marriage date with this formula:

DATETIME_DIFF({Married On}, {Birthday}, 'years')