(Convert.ToDecimal(row(5))>0.0) And (Not row(6).ToString.IsNumeric) And (row(8).ToString.Equals(builtDate.ToString))
The builtData variable holds a string value of a date formatted like yyyyMMdd.
I first added every condition in bracket thinking it was an error given because of the And Not given that it was written:
Convert.ToDecimal(row(5))>0.0 And Not row(6).ToString.IsNumeric And row(8).ToString.Equals(builtDate.ToString)
Also checked to see if the “>” condition wasn’t working given that I compared it to “0” instead of “0.0”
The data in row(5) can either be a year or a positive/negative decimal or integer.
The data in row(6) can either be a month written in numeric form or a string with a Name.
The data in row(8) is a date, type string written in the format yyyyMMdd.