Date values inconsistency in excel

Help Activities
1

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.

2

HI @Sonalk

Have a look on the document

Regards
Gokul

3

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

4

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

5

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)

6

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

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.