Getting error while calculating the date difference

Help Studio
, ,
1

Hello Team,

Getting error while calculating the date difference.
Can anyone please guide, what is the issue

Expression - DateDiff(DateInterval.Day, DateTime.ParseExact(date1, “dd.MM.yyyy”, System.Globalization.CultureInfo.InvariantCulture), DateTime.Now).Tostring

image

2

Hi @vaibhav2.chavan

Please give a try with

DateDiff(DateInterval.Day, DateTime.ParseExact(yourStringVar, "dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture), DateTime.Now()).ToString()

Make sure the variable you are passing is type String

Regards!

3

To make it easier you can also use modify date activity:
image

4

@fernando_zuluaga - Still getting the same error

image

5

@iamNairda - Can you please give the example how to use this activity?

6

Hi @vaibhav2.chavan

How about this expression?

DateDiff(DateInterval.Day, DateTime.ParseExact(Date1, "dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture), DateTime.Now).ToString()

image
image1148×276 26.5 KB

Check out this thread and blog

Check out the Details of Modify Date activity

The Modify Date activity in UiPath is used to update a date value using modifications including adding or subtracting days and finding the first or last day of the week, month, or year

Here is an example of how to use the Modify Date activity to add 7 days to a date:

  1. Drag and drop the Modify Date activity onto your workflow.
  2. In the Properties panel, set the DateToModify property to the date you want to modify.
  3. Set the DaysToAdd property to 7.
  4. Set the Result property to a variable that will store the modified date.

You can also use the Add Days method of the DateTime object to add or subtract days from a date.

Check out the Docs

https://docs.uipath.com/activities/other/latest/user-guide/modify-date

Regards
Gokul

1 Like