Code Fix: Unable to export a report to Microsoft Excel when the date format is set to dd/M/yyyy

  • 16 February 2021
  • 0 replies
  • 19 views

Badge +9
 

Code Fix: Unable to export a report to Microsoft Excel when the date format is set to dd/M/yyyy

KB002963

PRODUCT
K2 Five 5.2
K2 Five (5.2) Fix Pack 20

 

Issue Description

When you open a report from the Smart Starter App and attempt to export the report to Microsoft Excel, an error occurs when the date of the environment is set to dd/M/yyyy.

Error Message

The following error occurs: “The conversion of a varchar data type to a datetime data type resulted in an out-of-range value”.

Resolution

  1. Ensure you have K2 Five (5.2) installed.
  2. Download the K2 Five (5.2) FP20 from K2 Partner and Customer Portal.
  3. Install the K2 Five (5.2) FP20 to apply the fix.
  4. Refresh the browser cache.

 


0 replies

Be the first to reply!

Reply