05-14-2009 01:51 PM
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?
05-14-2009 02:07 PM
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.
05-15-2009 08:09 AM
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.
05-15-2009 08:32 AM
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?
05-15-2009 08:57 AM - edited 05-15-2009 08:58 AM
05-15-2009 09:11 AM
04-19-2011 02:30 AM
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 !!!!
04-19-2011 04:56 AM
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.