No converting the format to compare with other date in excel.
I am tracking dt to to excel
In that case, you may want to remove formatting in your excel if any. Just clear format for that particular column and try it again. I try it and it is working for me. I believe, issue is not with UiPath but issue is with Excel. To ensure you can write DataTable to new Excel file. Just use Write Range Activity and create new file and see outcome.
how to format in uipath
row.item(“date”)=DateTime.ParseExact(row.Item(“date”).ToString,“yyyy-MM-dd”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”)
not working throwing error
not of correct format
First you need to define proper column format in Excel and then write into Excel file. Once you changed the format then only it should work.
Ok every time I run, I have to clear the old Data?
How do I delete that via Uipath.
Before writing to excel it is throwing error. Date is of not proper format
ok a row contains date format and somewhere it appears text. Hence not taking assign activity in for each
Hi @KarthikBallary,
using the below activity, It will convert the data table column to the DateTime column. No need to use the for each loop.
Regards
Balamurugan.S
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.