US Region setting shows 'Date Control' day, one day before the date shown on SQL Server Date Property Column
kbt145291
PRODUCTK2 Five
K2 smartforms
BASED ONK2 smartforms (all)
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.
Issue
The incorrect dates get populated on the Date Control from the SQL Server.
Example:
The date control shows 2018/05/06 but will display in SmartForms as 2018/05/05.
Symptoms
Incorrect dates (usually one day before) are displayed on Views and Forms.Troubleshooting Steps
To resolve this, verify if the .NET Globalization Culture is in line with the Regional setting.
1. Navigate to IIS Manager
- Click on the K2 Web Application (K2)
- Click on the .NET Globalization and confirm if the Culture is en-US.
Please note! An IISReset needs to be done and your browser cache will need to be cleared.