Overload for "To String"

jagmanvdp

Apologies in advance, as I think this topic was dealt with awhile ago, but I cannot find the discussion related to it anymore.

When I Update PSDATA, I get the update to complete as it should and I am not missing any data etc, but I do get some errors as it runs and I was hoping to get it cleaned up a bit so I do not get the errors anymore. Here's what the errors look like.





Thanks in advance for your assistance

Darren

VidasMatelis

Hi @jagmanvdp,

Likely the issue is in the Transactions worksheet, column Date. You might have a transaction record without date or with date that does not exists (like Feb 30). Can you review all records and check if any dates are not right.

jagmanvdp

Thanks for the advice....I will start checking....Could a date that does not exist in the quotes section also cause this issue?

VidasMatelis

Error message indicated error in the file GetExcelSrcData and the line that extracts data fro Transactions worksheet. Most likely date is not right, but could be also other column.

jagmanvdp

Hello
Thank you for the help. I feel rather silly. I found some blank rows in the transaction table that were hidden. Once I erased them, the error was resolved.
Thanks!