Versions Compared

Old Version 8

changes.mady.by.user Andrew

Saved on

compared with

New Version 9

changes.mady.by.user Justin

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. for example (Example: "yyyy-MM-dd" for "2011-06-0111". )
Read the Date Format Pattern Syntax documentation for a list of date formats you can use.

Display Date Format

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

Sample Usage

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

...

In this example, without the use of Date Formatter, the Data Date Format would be in Java date format of "dd-MM-yyyy hh:mm aa".

With the use of the Date Formatter, we will change the Display Date Format to Java date format of "hh:mm aa dd/MM/yyyy".

Do note that this setting does NOT change the actual formatting of the date, but merely on how the date is displayed.

...