Cannot change Text type to Time: "Conversion failed when converting date and/or time from character string"
KBS100157
PRODUCTK2 Five
K2 blackpearl
TAGSK2 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:
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.
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.