Equation to count how many months passed from a certain date until today

Help Center Get Answers
1

Hi Everyone,

Does anyone know to create an equation to calculate the number of months passed from a certain date until current date?

Tks a lot!

2

This is a starting point. Might have to figure out negative. This might be too simplistic. Might have to work with years too to get months to go higher than 11.

In the Equation of an Equation field

currentTime() gets you the current date

getDateMonth gets you the month

{Scheduled} is a date field in my app

getDateMonth(currentTime()) - getDateMonth({Scheduled})