Question about converting exponential values in DT

[Ankur]

Values in VBScript are accurate to 15 digits only. This should set you in the right direction (taken from http://www.windows-api.com/microsoft/VBS...stion.aspx )

Code:

Wscript.Echo AddInts(148991, 76561197960265728)

Function AddInts(lngValue1, lngValue2)
Dim V1Hi, V1Lo, V2Hi, V2Lo
Dim Temp1, Temp2, Carry, A1, A2, A3

V1Hi = Fix(lngValue1 / (10^10))
V1Lo = lngValue1 - (V1Hi * (10^10))

V2Hi = Fix(lngValue2 / (10^10))
V2Lo = lngValue2 - (V2Hi * (10^10))

Temp1 = V1Lo + V2Lo
Carry = Fix(Temp1 / (10^10))
A3 = Temp1 - (Carry * (10^10))
Temp2 = V1Hi + V2Hi + Carry
A1 = Fix(Temp2 / (10^10))
A2 = Temp2 - (A1 * (10^10))

AddInts = CStr(A1) & CStr(A2) & CStr(A3)

End Function