< class="prominent-subhead ">

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

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 editing your SmartObject, and changing the property, after you click Finish, the following error is shown:



This may happen when you have a SmartObject property of type Text, and you want to change it to Date\Time, 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.