Skip to main content
Nintex Community Menu Bar

Wrong date time values are exported to Excel from List View

  • February 16, 2021
  • 0 replies
  • 374 views
  • Translate

Forum|alt.badge.img+7

Issue

If you are trying to export the results from a List View to Excel, and your view contains date time values, then you will notice that the exported records in Excel is not showing the same date time values that your view is showing.

 

21145iB0450571DAF5C076.png

Diagnosis

When your form or view retrieves any date time values from a SmartObject, the date time values that are being fetched has been converted into UTC time zone. SmartForms will detect your user's browser's locale settings, and convert the date time values into the time zone they are currently in. 

 

However, when you use the Export to Excel function to export the records in a List View to Excel, the date time values that get exported is in UTC time zone, rather than the values that your users are seeing on their browsers. This is why you will notice the date and time values being exported do not match with the values you are seeing.

 

Resolution

If you do not need to store the time, then you can update your data source to only store the date instead of the time. For example, if you are fetching your results from a SQL table, then update the data type for the column that stores the date time to only store the date. Without the time, K2 will not perform any time zone conversions.

 

If you need to store and display date time, then you can consider the workaround from here.

 

Additional Information

 

Did this topic help you find an answer to your question?

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings