Need to make the difference of column with another

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.


1 Like


I think below link will solve your problem,

Hi Pankaj.Patil,

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


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 ! :grinning_face_with_smiling_eyes:

Hi Hiba,

Thanks to the file.

I have a problem :

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


@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 !


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 :+1:

1 Like

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