Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
|Date stored in UTC timezone
|Click this checkbox if you are storing dates in UTC timezone in database.
|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. (Example: "yyyy-MM-dd" for "2011-06-11")
|Display Date Format
Use Java date format. (Example: "dd/MM/yyyy" for "11/06/2011")
When this field is left empty, the following will be considered.
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.
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.
After then, you can see the result of this configuration in datalist preview and runtime.