Changing date or timestamp format

When data is added, Qlik Sense automatically interprets the field type of each field. The following field types are currently supported:

• ⏪ General
• G Date
• õ Timestamp

If the data was not interpreted correctly as a date or a timestamp, you can adjust the input format in the table editor. You can also change the display format of a data or timestamp field.

To open the table editor, click @ on the data table you want to edit.

It is not possible to change field type or display format of fields in some cases.

• The table is the result of concatenating two or more tables.
• The field is already recognized as a date or a timestamp.

Making sure a date or timestamp field is recognized correctly

If a date or timestamp field is not recognized as a date or a timestamp, that is, it is marked with ⏪ General, you can make sure it is interpreted correctly.

Do the following:

1. Click on ⏪ below the field heading.

   The data format dialog opens.

2. Change Field type to Date or Timestamp.

3. Change the format string in Input format to interpret the date correctly. You can use a prepared format from the drop down list, or write your own format string.

   See: Conventions for number and time formats

   Information noteIt is not possible to use a single quote in the format string.

4. If you want to use a display format other than the default format in your app, write or select a format string in Display format.

   If you leave it empty, the app default display format is used.

5. Click outside the data format dialog to close the dialog and update the field.

Changing the display format of a date or timestamp field

Each app has default display formats for date and timestamp fields. You can change the display format for an individual date or timestamp field.

Do the following:

1. Click on G (date) or õ (timestamp) below the field heading.

   The data format dialog opens.

2. Change the format string in Display format. Either use a prepared format from the drop down list, or write your own format string..

   See: Conventions for number and time formats

3. Click outside the data format dialog to close the dialog and update the field.