No ratings

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


How to remove a trailing character

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.


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

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.


Labels: (2)
Version history
Last update:
‎04-12-2022 05:04 AM
Updated by: