Subtract 4 or 5 hours

[Steven Young]

Hey folks,

I need some help if you can spare me a few minutes.

I'm doing an import of Servers and we are trying to acquire the "Last Boot" time, which is being monitored.

I have a regular "String" field in SN.

and i'm trying to import a date.   I'm having an issue because SN keeps detecting it as a date/time and transforming it to GMT.

I have tried getting the value of the field,and doing a toString(), putting it in the string field.   No worky.

and date/time fields are still very confusing to me the way scripts need to be run in order to get the accurate time for you timezone, because of the date/time always being in GMT.

Can anyone help me with a script for my Timezone and to account for Daylight Savings Time?

The import field looks like so:  

9/9/2009   12:00:00 PM

4/10/2015   11:59:00 AM

1/12/2016   8:16:00 PM

1/14/2016   5:40:00 PM

the import transforms it to:

4/1/2014   1:12:00 AM                 >>>>>>>>>>>             2014-04-01 05:12:00

var boot = source.u_last_boot;
target.u_last_boot = boot;

I have looked at the wiki but dont understand how to write a script that looks at current timezone, accounts for daylight savings time, and give me my localtimezone value.

But more importantly, i dont understand why SN has to turn a string going to a string, into a date/time value?

I'm currently in Eastern US time zone.

My system time is Eastern US time zone.

[Ankur Bawiskar]

Hi Steven,

Since the target field is a date time field and the field in which you are storing the incoming date time is a string, it is behaving in this way. Is the field in which you are storing the incoming value a date/time field?

You can specify the format in the field map such as mm-dd-yyyy or yyyy-mm-dd. This helps in transforming whatever value is coming into the target table. This field map should not be affected with the time zone. You can check the same.

Mark Correct if this solves your issue or hit Like and Helpful if you find my response worthy based on the impact.

Thanks

[Steven Young]

No.   the field i'm trying to import to is a "String" field.

i set it as a string field because i thought that SN would leave the data along and just import what i wanted to import.

i'm getting a date/time from a field on the import.

turning it into a toString()

importing into a "string" field.

[Steven Young]

to manually take of 4 hours, i'm doing the following.

var boot = source.u_last_boot;
var boottime = new GlideDateTime(boot);
boottime.subtract(14400000);
target.u_last_boot = boottime;

[Abhinay Erra]

Also set the time zone to your current time zone.

var boottime = new GlideDateTime(boot);  

boottime.setTZ(gs.getSession().getTimeZone());

boottime.subtract(14400000);      

target.u_last_boot = boottime.getValue();