I've got a view in a SmartForm that's showing the date incorrectly. The view uses an Azure SQL-based data source and the dates show up correctly in SQL when I query the database, but when it shows up a day earlier in the view. For reference, I'm in PST. Anyonw know why this might be the case?
Solved
K2 Cloud Smartform view showing incorrect date
+3Best answer by Vernon
I have seen this happen when SQL and View control doesn't use the same data type. IE, SQL uses Date and View Control uses DateTime.
HTH
Vernon
View originalHTH
Vernon
+7Hello
When configuring the servers for DateTime cultures in K2 smartforms, it is important to ensure that all servers are using the same timezone and culture settings. This will prevent issues with datetime values.
Please take a look here: https://help.k2.com/kb001458 to help solve your issue.
Enjoy
Translate
Good day RayBoone
Please also see the following.
Calendar Control displays a different Date value in different Time Zones: https://help.k2.com/support-services/kbt135043,
“Calendar control using SQL DateTime value showing wrong day”: https://community.k2.com/t5/K2-blackpearl-Articles/Calendar-control-using-SQL-DateTime-value-showing-wrong-day/ta-p/90216.
Best,
Sunrise
Please also see the following.
Calendar Control displays a different Date value in different Time Zones: https://help.k2.com/support-services/kbt135043,
“Calendar control using SQL DateTime value showing wrong day”: https://community.k2.com/t5/K2-blackpearl-Articles/Calendar-control-using-SQL-DateTime-value-showing-wrong-day/ta-p/90216.
Best,
Sunrise
Translate
+14I have seen this happen when SQL and View control doesn't use the same data type. IE, SQL uses Date and View Control uses DateTime.
HTH
Vernon
HTH
Vernon
Translate
+3That fixed it--what you described is exactly what was going on. View had it as a date/time and the SQL data type is date. I went into the SmartObject and changed the data type to date and all is good. Thank you!
Translate
+3The fix was making the view and SQL both use Date. One had date/time, the other was date.
Translate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.