today1 is a string variable containing a date
today1 - string - new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(1).AddDays(counter).ToString(“MM/dd/yyyy HH:mm:ss”)
originally tried the assign value as row(new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(1).AddDays(counter).ToString(“MM/dd/yyyy HH:mm:ss”)) but that resulted in an unknown error “Invalid L value” so I tried assigning it to a variable and this is the result. as seen from Invalid L value? - #3 by lmoham, I paid it no mind as it was a quick fix that got rid of any error alerts till now when I eventually try to run the full project.
Pretty strange name to give to a column… Any way, I’m assuming this column exists. Can you check what’s the column type and if it’s Integer or Object? If it’s string, trying to assign it an Integer may generate this type of errors.
For now, can you check content of $ExceptionDetail at Locals Panel when error occurs, as the following? This helps to solve issue. (For example, the following shows mismatch column name)