6/20/2025 10:31:29 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Timezone settings change between tables
Posted: 12 Nov 07 10:34 AM
|
Would appreciate any ideas on this one. I have two tables with a 1:1 relationship, Opportunity (the default slx table) and C_OppAddl (our table). I placed two datetimeedit controls on the opportunity detail form, one pointing at Opportunity.EstimatedClose field and one pointing at C_OppAddl.EndDate. Opportunity.EstimatedClose is being stored in SQL server as the literal time I put in, e.g. 11:05 AM -> 11:05. C_OppAddl.EndDate is being stored in GMT, e.g. 11:05 AM -> 16:05. A trace on the server shows that the dates are coming from, presumably, the GUI or the OLEDB Provider, as they are literally being inserted/updated this way by the time they get to SQL server.
I have tried switching the values that the controls point to and deleting and re-adding the controls without any luck, the behavior is very consistent between these two fields. I even removed this field from the insert opportunity form in case some setting was (somehow) getting carried over from the insert operation. Any ideas? Saleslogix version is 7.2, have tried restarting the client a number of times, adding new entries, nulling out and re-adding, etc.
Thanks in advance,
Clay |
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|