Date values inconsistency in excel

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.

  1. Is there any workaround to solve this in existing build?
  2. 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.

HI @Sonalk

Have a look on the document

Regards
Gokul

Thanks @Gokul001 . I am looking conversion logic without packaged activities.

HI @Sonalk

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

Regards
Gokul

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.