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″)