Convert date using vbs
Posted on 2013-12-12
I have syslog data being parsed in SCOM to a text file using a vbs script which is then used to import into an SQL database. The date field that comes out of the syslog is not acceptable by SQL standards.
I am looking for a way in vbs to convert a date field from "Dec 12 14:30:25" to "2013-12-12 14:30:25"
I am happy to use year(now) to give me the current year, but need to know how I would feed it all into a variable that I can use.