Was working on a little side project this weekend and came up with a formula to calculate the upcoming birthday of someone based on a field called Birthday containing the persons full birthday. ChatGPT and AI kept trying to make it more complicated with IF statements. Thought it might be helpful for the community archive:
DATEADD({Birthday}, (DATETIME_DIFF(TODAY(), {Birthday}, 'years')+1), 'years')
Here it is in action. So if their birthday has already happened this year, it jumps to next year’s birthday. If their birthday hasn’t happened yet, it still gives the correct upcoming date automatically - no IF logic required.
