Let's say that you have such use cases:
- Calculate a person's age based on a column that stores the person's date of birth
- Compare a date with the current date to calculate how long it has elapsed since
- etc.
To fulfill this case, you can simply use a Bean Shell Formatter on a column with date values to perform the calculation with this script below:
import java.text.ParseException;
import java.time.LocalDate;
import java.time.Period;
try {
LocalDate birthDate = LocalDate.parse(value);
LocalDate currentDate = LocalDate.now();
Period dateDiff = Period.between(birthDate, currentDate);
return dateDiff.getYears() + " YEAR(s) & " + dateDiff.getMonths() + " MONTH(s)";
} catch (ParseException e) {
e.printStackTrace();
}