Converting Marimba Dates

In the course of reviewing Marimba logs you may encounter dates in long integer format. Use the following vbscript to convert these to mm/dd/yy format. You may need to modify the value of tzadjust (currently set to -6 on line 2) depending on your time zone.

temp = InputBox(“Enter a Marimba date, i.e. 1265695200000.”)
tzadjust = – 6 ‘ central time = GMT -6
temp = temp + (tzadjust * 3600 * 1000)
temp = DateAdd(“s”, temp/1000, “Jan 1 1970″)
WScript.echo temp

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Follow

Get every new post delivered to your Inbox.

%d bloggers like this: