Export to Excel function in K2: datetime data is not displayed the same as on the SmartForm

[#1]

How to remove a trailing character

kbt163432

PRODUCT

K2 Five

BASED ON

K2 Five 5.4

This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice. This article is not considered official documentation for K2 software and is provided "as is" with no warranties.

Objective

When using the export to Excel function in K2, the datetime format in Excel is not displayed the same as the screen in SmartForm.

Before You Begin

Date values inherit the styling from the client local cultural settings and we can not set the style formatting on the datetime column for export to Excel.

Please see the considerations listed here.

How-to Steps

Workaround
You can use expressions to display datetime formatting in export to Excel. Please refer to the picture below.

1. Add a Data Label to the new column.

2. Set the expression with a specific datetime format to the new column.

3. Export to Excel with the new datetime column.