I am updating ‘10 March 2021’ value in excel column as 10/03/2021 but value got changed to 03/10/2021 after appending records to excel from datatable.
- Is there any workaround to solve this in existing build?
- How to solve them in excel to avoid issues ?
I have tried this assignment ( CDate(in_value).ToString(“dd/MM/yyyy”)) before adding records in datatable.
Have a look on the document
Thanks @Gokul001 . I am looking conversion logic without packaged activities.
How about this expression?
DateTime.ParseExact(in_Value,"dd MMM yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")
in_Value Format - dd MMM yyyy
Hi @Gokul001 : I have tried this expression but It was not resolved with this expression.
I have solved this by changing data type to generic and use Append Range activity in System–>File → Workbook (instead of using Append Range under App Integration)
Hi one trick to use, use '(single course like : '10 March 2021) in front of dates in excel then it will take that in string format and there will be not issue while reading data in UiPath
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.