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) {

  • No labels