Joget Workflow v6 Released
Check out the latest Joget Workflow v6 for many new features and improvements in user experience (UX), app maintainability and performance.
The Date Formatter allows you to transform existing date to another date format.
Figure 1: Date Formatter Properties
|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
In this example, we will format the column "Date Created" (dateCreated in database table) to another date format in Datalist Builder.
Figure 2: SQL client view on data table
The Data Date Format that we should set should be based on preview from the Datalist Builder itself.
Figure 3: Datalist Builder list view without Date Formatter
In this example, the Data Date Format would be "dd-MM-yyyy hh:mm aa".
Figure 4: Date Formatter properties
Figure 5: Datalist Builder list view with Date Formatter enabled on Date Created column