SLX Web 7.5 - GMT Conversion

[henrycohen29]

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

[MikeSpragg]

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.

[henrycohen29]

It already is D in sectabledefs.

[RJLedger]

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. 

[henrycohen29]

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

[tagersea]

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

[RJLedger]

No different.

[jack4slx]

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 !!!!

[RJLedger]

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.

[jack4slx]

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