Symptoms

K2 blackpearl / Running Smartobject list method with DateTime column cannot return data properly
 

Diagnoses

While executing smartobject method under K2 studio, K2 automatically assign "2001-01-01T00:00:00" to all datetime column while investigating under "servicePackagein.log". Attachment with db script to create database , sample data and K2studio workflow
 

Resolution

Change the regional date format to mm/dd/yyyy for the profile of the K2 service account on the K2 blackpearl, smartform server