CMDB script. datetime conversion that sql accepts

Vote count:

0

Have been searching for ever to try solve my issue. As i'm not any good in vb scripting and have to solve the issue i turn to you for help.

The current info needs to be handled:

Tid:            13.12.2014 01:48:48

what the script contains handling this is:

 if isArray (arrString) then
            if uBound (arrString) > 0 then
                Select Case lcase (arrString(0))
                    Case "tid": tid = trim (arrString (1)) & ":" & trim (arrString (2)) & ":" & trim (arrString (3))

When inserting this into sql it returns : the conversion of a varchar data tye to a datetime data type resulted in an out-of-range value

I cant find the reason why it wont work now. The database was moved from a 2003 to a 2008 r2

asked 29 secs ago

vya

12

CMDB script. datetime conversion that sql accepts