Date is off by 10 hours

[AFR]

Hi,

I have a module where user specifies the date using the calendar. I can see from the SM7 screen that the date is August 1, 2009 but when connect-it runs the value of the date that its seeing is July 31, 2009 2PM.

How can I fix it so that they can see the same thing?

In my javascript, I always set the value to:

effective_date = system.functions.date(system.functions.val(effecti ve_date,3))

I do it this way so that the returned date will always have a 00:00:00 time.

Regards,

Ann

[glg]

connect-it is running in GMT, you need to set it's timezone or do a date conversion in the mapping.

[AFR]

Appreciate the quick reply.

Our connect-it guy says that the connect-it is using the timezone setting and date format in SM7.

What kind of script is connect-it using? I'm not really familiar with it.

Can you give me a piece of code that I can just put in the scenario.

[harn145]

The account CIT uses could have a tz against it, is what glg was trying to say. So SM will provde the date/time stuff already in the tz for the user.

[AFR]

both accounts (the one who create the record and the account that the CIT uses) has the same TZ settings in the operator file.

our CIT guy just added a date conversion in the mapping based on the value of the the timezone offset.

thanks for the suggestion glg, appreciate it.

[tommy]

In connect it when configuring the SM connection there is an option for CIT to determine the time difference between the 2 servers (advanced settings as far as I remember). Use that instead of making manual conversions.