›

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links

Categories

Overload for "To String"

jagmanvdpjagmanvdp
in External Data Files
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

Comments

  • VidasMatelisVidasMatelis
    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.
  • jagmanvdpjagmanvdp
    Thanks for the advice....I will start checking....Could a date that does not exist in the quotes section also cause this issue?
  • VidasMatelisVidasMatelis
    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.
  • jagmanvdpjagmanvdp
    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!
Sign In or Register to comment.