Need to make the difference of column with another

[Al_Bert]

Hi all,

I have 2 columns:
Column-1 - the dates from datas
and Column-4 - result of the difference between the Column-1 and the date of today.

I cannot find the right formula for the Column-4 column to have the days between the date in the Column-1 column and today’s date.

Thanks to your help.

AL

[Pankaj.Patil (Robot Master)]

@Al_Bert,

I think below link will solve your problem,

Get calendar days between two dates

[Al_Bert]

Hi Pankaj.Patil,

Thanks to this link, but concretely, how will it be translated in UiPath?

AL

[Hiba_B (Hiba Beldi)]

Hi @Al_Bert !

Here is a suggestion: Difference_of_dates_in_columns.xaml (7.1 KB)

Let us know if it does not work as expected !

[Al_Bert]

Hi Hiba,

Thanks to the file.

I have a problem :

Assign: Conversion from string “25/05/2021” to type ‘Date’ is not valid.

[Hiba_B (Hiba Beldi)]

@Al_Bert Interesting, with the same data I am not able to have the error:

I suggest then the following workflow, but I am not able to know if it will help or not:
Difference_of_dates_in_columns.xaml (11.0 KB)
If it does not work, do the following:

Let us know if it still does not work as expected !

[Al_Bert]

@Hiba_B

I suggest then the following workflow, but I am not able to know if it will help or not:
Difference_of_dates_in_columns.xaml (11.0 KB)
If it does not work, do the following:

Hiba,

I just changed into :

DateTime.ParseExact(row(“Column-1”).ToString, “dd/MM/yyyy”, System.Globalization.CultureInfo.CreateSpecificCulture(“fr-FR”))

Thanks to your help.

Great job