0

I am in the process of converting a program from vb 6 to VB.Net. I am taking a large amount of data and placing it in the proper sql collum.
Any help will be greatly appreciated.

I am getting this error code here:

If ExistsInrsTemp("NextMthDue") = True Then

If InStr(NullSafeValue(rsTemp, "NextMthDue"), "/") > 1 Then
 Mid(sDocTrans, 43, 2) = Format(CInt(Left(NullSafeValue(rsTemp, "NextMthDue"), InStr(NullSafeValue(rsTemp, "NextMthDue"), "/") - 1)), "00")

 Mid(sDocTrans, 45, 2) = Format(CInt(Mid(NullSafeValue(rsTemp, "NextMthDue"), InStr(NullSafeValue(rsTemp, "NextMthDue"), "/") + 1)), "00")

End if 

Edited by pritaeas: Added markdown.

2
Contributors
2
Replies
15
Views
2 Years
Discussion Span
Last Post by Zulu79
0

Thank you. I did some reseach, and the user entered the wrong vaule.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.