Assign: Exception has been thrown by the target of an invocation assign date row

[lmoham]

Hi, can someone explain what the error above means and any possible solutions to fix it?

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.

[RockSolid (Martí Pomés)]

Hi Lmoham,

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.

Thanks,

Martí

[Yoichi]

Hi,

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)

Regards,

[lmoham]

Hi, the problem was a fault on my part, there was a variable within the variable not accounted for as well as badly placed scopes.