The DayBetween function returns the number of days between the two dates. For example: I was born on «FormatDate(DateOfBirth,‘d MMMM yyyy’)» which means I am «floor(DaysBetween(Today(),DateOfBirth) div 365.25)» years old.

The MonthsBetween function returns the number of months between the two dates.   Below are 2 examples of the function: «Comment(Pass in 2 data elements, a start and an end date)» «MonthsBetween(FirstDate,Secondate)» «Comment(Another example is where one of the parameters is a function such as Today())» «DaysBetween(ChooseMonth,Today())» «ChooseUsingDatePicker(ChooseMonth)»

As its name suggests, this function takes two dates as arguments and returns the difference as a number of years, months and days. It is not the same as combining the results of the MonthsBetween and DaysBetween functions together with the YearsBetween function. The simplest form takes only the starting...