Need to make the difference of column with another

Help Activities
, ,
1

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.

image
image1636×159 13.4 KB

Thanks to your help.

AL

1 Like
2

@Al_Bert,

I think below link will solve your problem,

3

Hi Pankaj.Patil,

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

AL

4

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:

5

Hi Hiba,

Thanks to the file.

I have a problem :

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

image

6

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

image
image732×149 4.26 KB

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:
image
image551×659 17.6 KB

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

7

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

1 Like
8

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