...
Table of Contents
...
| borderColor | green |
|---|---|
| borderWidth | 1 |
| titleBGColor | #ddffcc |
| borderStyle | solid |
| title | Definition |
Introduction
The Date Formatter allows you to transform the existing date to another date format.
Figure 1:
Date Formatter Properties
Configure Date Formatter
| Name | Description |
|---|---|
| Data Date Format | In Java date format. e.g., yyyy-MM-dd for 2011-06-01 |
| 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.
...
Figure 2: SQL client view on a data table
The Data Date Format that we should set should be based on preview from the Datalist Builder itself.
...