My Excel file data show below
Then I do read range to keep data into DT1 variable datatable type (with header selected)
And I do read cell to get column name of column 2 which is datetime type, it is 12-May-18. Keep into Header variable string type
I have created the datarow type variable called DTrow1
After that I use Assign activity to do select datatable, propose to remove row 4 and 5 because of it contain blank data.
I assigned DTrow1 in the left side and DT1.Select(Header+" <>‘NULL’") in the right side.
But it shown error that “Cannot add System.DateTime to System.ToString”
How can I solve this, need your professional guy help sir.
Thank you very much.