You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

Introduction

The Date Formatter allows you to transform the existing date to another date format.

Date Formatter Properties

Configure Date Formatter

NameDescriptionScreens (Click to view)
Data Date Format

In Java date format. e.g., yyyy-MM-dd for 2011-06-01
Please see simpleDateFormat for a list of formats.

Figure 1: Date Formatter Properties

Display Date Format

In Java date format.

e.g., dd/MM/yyyy for 01/06/2001

Sample Usage

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

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)

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

With the use of the Date Formatter, we will change the Display Date Format to "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.

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




  • No labels