Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Introduction

English
The Date Formatter allows you to transform the existing date format to another date format for datalist display.

Date Formatter Properties

Configure Date Formatter

Image RemovedImage Added

NameDescription
Date stored in UTC timezoneClick 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")
Read the Date Format Pattern Syntax documentation for a list of date formats you can use.

Display Date Format

Use Java date format. (Example: "dd/MM/yyyy" for "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.

  1. If current locale starts with "zh", the format will be set as "yyyy-MM-dd".
  2. If "Using Locate Date Format" is set in General Settings, date format based on current user's locale will be used.
  3. Otherwise, it will use "MM/dd/yyyy".

...

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 RemovedImage Added

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

...

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

Demo App