Cannot change Text type to Time: "Conversion failed when converting date and/or time from character string."

  • 15 February 2022
  • 0 replies
  • 45 views

Userlevel 5
Badge +19
 

Cannot change Text type to Time: "Conversion failed when converting date and/or time from character string"

KBS100157

PRODUCT
K2 Five
K2 blackpearl
TAGS
K2 SmartObject Integration
SmartObjects
SmartForms Designer
Troubleshooting Document
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.

Issue

When editing your SmartObject, and changing the property, after you click Finish, the following error is shown:

Image

Symptoms

This may happen when you have a SmartObject property of type Text, and you want to change it to DateTime, while data exists within the SmartObject.

Image

Image

 

Troubleshooting Steps

This is expected behavior, and not an issue with the K2 Product.

The reason is, K2 cannot convert existing data into different data types. You will experience the same issue when you try to change existing String data to Int within SQL Management Studio.


0 replies

Be the first to reply!

Reply