Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

If you want to display dateCreated and dateModified based on timezone you will need to use bean shell formatter on the date column.

Use this bean shell code for the formatter.

Code Block
languagejava
linenumberstrue
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;