Hi genti,

Try out this sample app below. Check out the script in the Bean Shell Datalist Formatter for the "Calculated Age" datalist column.
Feel free to modify the code to match your exact requirement.

APP_beanshellformatter_calculation-SAMPLE.jwa

Code snippet:

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Calendar;
 
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
try {
    Date birthDate = formatter.parse(value);
    Calendar birthDateCal = Calendar.getInstance();
    birthDateCal.setTime(birthDate);
    
    Date currentDate = new Date();
    Calendar currentDateCal = Calendar.getInstance();
     
    return (currentDateCal.get(Calendar.YEAR) - birthDateCal.get(Calendar.YEAR)).toString();
} catch (ParseException e) {
    e.printStackTrace();
}

Hi, In the sample the data list is empty, no columns. In the userview when I click on properties of Manage Test nothing happens, it does not open.

I am using joget 6

I'm currently using Joget DX. If its possible for you, I think its best to upgrade. Comes with more features and crucial security patches.

On another note, you also must be using Java 8 or above in order for the script to work. Just use a Bean Shell Formatter on your datalist column that has the date values, and paste in the script above.

Hi,

Same on joget DX and I am using java 8

Hmm this is strange. Try importing the app to another Joget instance to rule out any issues with the sample app above.

On the other hand, I found this guide here that you can also refer to, so you can also insert the script into your own app. 

Compare Date Column Value with Current Date