Picker control displays Date format as YYYYMMDD
Picker control displays Date format as YYYYMMDD and does not convert datetime value as per user's locale settings. This is when using a SQL table as the data source.
Response from K2 LABS:
It seems that this is by design at the moment with the K2 Picker Control.
So this date format conversion would have normally been done through the "Format" option on the control properties window. But you will now see that the Format option there has been grayed out and is no longer available.
This is because the Format option is not supported in the control and as the developer pointed out the control will only display the underlying value exactly as it appears in SQL without formatting.
A possible workaround is to:
1) Format the datetime value in SQL to the desired format and save it in a SQL Stored Procedure.
2) Read the newly formatted data from SQL and it will show as desired in the K2 Picker Control.
Thank you for your feedback. We are exploring a way to include new controls easily into SmartForms, which may address your request. Stay tuned for more information, and we'll update the status of this request as projects continue.