Introduction

Date Formatter Properties

Configure Date Formatter

Image Added

Name	Description

Screens (Click to view)

Date stored in UTC timezone	Click this checkbox if you are storing dates in UTC timezone in database.

Image Removed

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-

01

11"

.

) 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/06/2001

"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. If current locale starts with "zh", the format will be set as "yyyy-MM-dd". If "Using Locate Date Format" is set in General Settings, date format based on current user's locale will be used. 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.

Image Modified

The Data Date Format that we should set should be based on the datalist preview from the datalist builder.

This may also be subjected to the system locale and date format attributes set in the System Settings. (Please see General Settings - Server Locale and Time Zone for more information)

Image Modified

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".

Image Modified

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.

Image Modified

After then, you can see the result of this configuration in datalist preview and runtime.

Demo App

• APP_datalist_date_formatter.jwa