Versions Compared

Key

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

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

Use this Java code in 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;