Knowledge Base for DX 7 : JDBC Datalist Binder Display dateCreated and dateModified Based on User Timezone

If you want to display dateCreated and dateModified based on user's timezone, you may use Bean Shell Formatter on the date column.

Use this Java code in the formatter.

import java.text.SimpleDateFormat;
import org.joget.commons.util.TimeZoneUtil;
import java.util.Date;
import org.joget.apps.app.service.AppUtil;

String pattern = "yyyy-MM-dd HH:mm:ss.S";
SimpleDateFormat simpleDateFormat = new SimpleDateFormat(pattern);
Date date = simpleDateFormat.parse(value);
value = TimeZoneUtil.convertToTimeZone(date, null, AppUtil.getAppDateFormat());

return value;