Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Copper Elite Contributor
Posts: 70
Registered: ‎04-30-2009

SLX Web 7.5 - GMT Conversion

Hi All,

 

I am doing development in SLX Web 7.5. I have two dateTime fields. In SQL server, when I query for them, I get a certain date, but then when I look in the web client, GMT conversion is being performed, thus giving me a different value.

 

What do I have to do to turn off GMT conversion in the web client?

 

Thanks!

~ Henry

Silver Super Contributor
Posts: 801
Registered: ‎03-24-2009

Re: SLX Web 7.5 - GMT Conversion

Why would you want to ? This is correct behaviour.

If, however, you absolutely need to for some reason - you can alter a flag in sectabledefs called datetimetype. Set this to "D" and GMT is not applied. But, look at what you need to do prior to changing this.

 

Copper Elite Contributor
Posts: 70
Registered: ‎04-30-2009

Re: SLX Web 7.5 - GMT Conversion

It already is D in sectabledefs.
Highlighted
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: SLX Web 7.5 - GMT Conversion

In the Windows client, the Provider does GMT conversion on the fly depending on what the local (desktop/laptop) settings are.

 

In the WEB...  the conversion is controlled by wherever the (client) browser is being executed. SInce the (client side) provider is NOT in the pc where the browser is located, the connection between IIS and the SalesLogix server does NOT do GMT conversion.

 

Otherwise, all rules apply. 

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Copper Elite Contributor
Posts: 70
Registered: ‎04-30-2009

Re: SLX Web 7.5 - GMT Conversion

ok, makes sense. In the LAN Client, that conversion can be turned off by setting the field to a Date only field.


How can we turn off the conversion for that field for the WEB Client?

 

Thanks

Bronze Super Contributor
Posts: 349
Registered: ‎03-24-2009

Re: SLX Web 7.5 - GMT Conversion

[ Edited ]
Was this flag changed after the field was added? If so you may need to restart the SalesLogix services as they cache metadata.
Message Edited by tagersea on 05-15-2009 08:58 AM
Timmus Agersea
Black Moth CRM
Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: SLX Web 7.5 - GMT Conversion

No different.
--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Bronze Super Contributor
Posts: 141
Registered: ‎02-22-2010

Re: SLX Web 7.5 - GMT Conversion

I am having the same issue. I have two fields called submission date and registration date. i have updated the sysdba.sectabledefs table as datetimetype "D" for both fields. But the still the issue exist. Please Help

Its urgent! My Client is Behind me !!!!

Smiley Sad

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: SLX Web 7.5 - GMT Conversion

Whan you make these kind of changes directly to the db via SQL.. you have to "reboot" the SalesLogix server to get the change to show up.

 

Remember, behind the scene it's still a normal DateTime field. This change a strictly a "SalesLogix Provider" related thing.

 

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Bronze Super Contributor
Posts: 141
Registered: ‎02-22-2010

Re: SLX Web 7.5 - GMT Conversion

I have rebooted the system and it is working fine now. Thanks RJ!!!!!!!!!!!!!!!!!!!!!