SPPS 2003: We have a Work Orders list that has a calculated column
'OpenDays' that identifies how many days the WO has been open. I have an
application that displays a dashboard of the status of open work orders. The
I need to get the 'OpenDays' but when I loop through the list items using
For l = 0 To listItems.Count - 1
Dim item As SPListItem = listItems(l)
Dim la As Integer = 0
la = item("OpenDays")
I get an Error:
[FormatException: Input string was not in a correct format.]
Microsoft.VisualBasic.CompilerServices.DoubleType.Parse(String Value,
NumberFormatInfo NumberFormat) +195
Microsoft.VisualBasic.CompilerServices.IntegerType.FromString(String
Value) +95
[InvalidCastException: Cast from string "float;#48.0000000000000" to type
'Integer' is not valid.]
How can I get the integer value ? I have haven't been able to find a way to
convert to integer.