Versions Compared

Old Version 9

changes.mady.by.user Justin

Saved on

compared with

New Version 10

changes.mady.by.user Hugo

Saved on

Key

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

...

NameDescriptionScreens (Click to view)
Date stored in UTC timezoneClick this checkbox if you are storing dates in UTC timezone in database.

Figure 1: Date Formatter Properties


Data Date Format

Set to follow your Joget System Settings > System Date Format, for example "dd-MM-yyyy hh:mm aa".

Use the Java date format. (Example: "yyyy-MM-dd" for "2011-06-11")
Read the Date Format Pattern Syntax documentation for a list of date formats you can use.

Display Date Format

Use Java date format. (Example: "dd/MM/yyyy" for "11/06/2011")
Read the Date Format Pattern Syntax documentation for a list of date formats you can use.

When this field is left empty, the following will be considered.

  1. If "Using Locate Date Format" is set in General Settings, date format based on current user's locale will be used.
  2. Otherwise, it will use "MM/dd/yyyy".

Sample Usage

In this example, we will format the column "Date Created" (dateCreated in the database table) to another date format in datalist builder.

...