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!

Administration Forums - Installation
Forum to discuss installing SalesLogix and general installation topics. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Installation | New Thread

View: Search:

Author

Thread: Saving Incorrect time into database

Martin Navarro
Posts: 18

Saving Incorrect time into database Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 24 Aug 06 11:48 AM

We recently converted to 6.2 from 6.1 ( don't know if this is related to this issue). The problem I am having is as follows:
When writing a record into the database, the createdate and modifydate is 5 hours ahead of what it realy should be...

... I have traced the code to the point just before the call to the objRS.Update and the time looks fine (what it should be).

... I have also, duplicated the same functionality in Query Analyzer and found no problemthere...

Thanks in advance for your help!

[Reply][Quote]

Marc Johnson
Posts: 252

Re: Saving Incorrect time into database Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 24 Aug 06 12:37 PM

I don't believe the problem is with your database. From 6.1 to 6.2 Sage added a bunch of time zone stuff to the system. This is part of the upgrade process. Did you run the GMT Conversion? It's been awhile since I've done it myself but I believe it's in that process that you set your local time zones for each user. Each user has their own time zone so that offices spread through-out the country (countries) can pass the system times that are correct for their location.

If you did not run the conversion at the time of upgrade you can go to C:\Program Files\SalesLogix on your administrative console and open the SLXTimeZones.exe to set your time zones. It can only be run once.

The only way I know of to change the Time Zone for each user at that point is to manually edit their TIMEZONE field in the database (Table name: USERINFO).

If anyone else has a different/better answer I'm interested also. There should be an easier way to change this, like if an employee transfers offices or moves.

Marc

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Saving Incorrect time into database Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 24 Aug 06 12:55 PM

Reply posted under thread in VBScript forum...

[Reply][Quote]

Marc Johnson
Posts: 252

Re: Saving Incorrect time into database Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 24 Aug 06 1:01 PM

A better reply than mine I might add. And here I thought I was pulling my weight for once answering instead of asking

[Reply][Quote]

David Henry
Posts: 207

Re: Saving Incorrect time into database Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 24 Aug 06 2:09 PM

Quote:

Originally posted by Ryan Farley

Reply posted under thread in VBScript forum...

Here is a direct link to the thread.

[Reply][Quote]

Martin Navarro
Posts: 18

Re: Saving Incorrect time into database Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 24 Aug 06 3:07 PM

Thakns a lot guys... it looks like I am geting somewhere...

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/22/2024 4:05:36 PM