whats wrong with this condition:
(Convert.ToDateTime(row(“Usage”+vblf+“Beg Date”))<now)
i am getting this error : If: Input string was not in a correct format
whats wrong with this condition:
(Convert.ToDateTime(row(“Usage”+vblf+“Beg Date”))<now)
i am getting this error : If: Input string was not in a correct format
Usage Beg Date is a column name, i gave vblf because the column name is present in two lines in the same cell. i am comparing the the usage date to the current date
You can take my below post as a reference to convert before making the IF condition
Mark as solution if this helps
Thanks
Hi @sybasha
Instead of this (Convert.ToDateTime(row(“Usage”+vblf+“Beg Date”))<now)
Use this CDate(row(“Usage”+vblf+“Beg Date”))<DateTime.Now
Hope this may help to solve your query
Definetly Mark this as solution if this helps you and like it
Happy Automation
Best Regards
Er Pratik Wavhal
Hi @sybasha
If my above solution worked for your issue then plzz mark it as solution.
Happy Automation
Best Regards
Er Pratik Wavhal
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.