Archive for June, 2010

Converting Marimba Dates

June 1, 2010

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

Advertisements