Home
Latest images
Search
Register
Log in
Heather@FootAnstey- Posts : 57
Join date : 2018-12-19
![[Search Lists] Date Column Properties and UTC Empty](https://2img.net/i/empty.gif)
[Search Lists] Date Column Properties and UTC
Fri 17 Apr 2020 - 15:09
Original Post: Mike Vaughan (Thompsons) 09/01/2014 10:23:15
"Can someone confirm if the Display properties of a searchlist column (DisplayDateAs and SourceDateIs) make any reference to the SQL Server timezone settings, or does it only look at the client PC timezone settings?
We need to know this because we're in the process of testing the many UTC scenarios there are with regards to the DateTime control 'DisplayDateAs' properties, manually inputting a date, assigning values to a DateTime control in code, noting how they are stored in the database and finally how they are displayed in a searchlist. We will have offices across many timezones with client machines connecting to subscribers with other timezone settings."
"Can someone confirm if the Display properties of a searchlist column (DisplayDateAs and SourceDateIs) make any reference to the SQL Server timezone settings, or does it only look at the client PC timezone settings?
We need to know this because we're in the process of testing the many UTC scenarios there are with regards to the DateTime control 'DisplayDateAs' properties, manually inputting a date, assigning values to a DateTime control in code, noting how they are stored in the database and finally how they are displayed in a searchlist. We will have offices across many timezones with client machines connecting to subscribers with other timezone settings."
Permissions in this forum:
You cannot reply to topics in this forum|
|
|