+3
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?
Best answer by Vernon
View original
+7
Hello
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
+14
+3
That 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!
+3
The fix was making the view and SQL both use Date. One had date/time, the other was date.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.