Subtract fixed value and dynamic value

Learning Hub Academy Feedback
1

I want to subtract fixed value- row valueCapture

B3 should be B1-A3
B4 should be B1-A4
B5 should be B1-A5
B6 should be B1-A6 and so on.

there will be around 80k rows

2

@Ananya1 Do you want the result in Days? or Years?
Yes, will get output in this format too.
You can use this function :
Date1=1995-01-16
Date2=1984-09-23
DateDiff(DateInterval.Year, Date1,Date2)

DateDiff subtracts the value of Date1 from the value of Date2 to produce the difference.

4

Could u plz share flow,

5

i want output in days

6

@Ananya1 Okay then just insert Day instead of Year

7

but for 80k rows, for each row will take lot of time

8

@Ananya1 Yes it might take longer time and you can also do this using select query
This will look like this
SELECT DATEDIFF(Day, ‘2017/08/25’, ‘2011/08/25’)

9

what is datediff

10

@Ananya1
DateDiff is function use to subtracts the value of Date1 from the value of Date2 to produce the difference.

A DateInterval enumeration value or a string expression representing the time interval you want to use as the unit of difference between Date1 and Date2 .

11

it didnot help

12

@Ananya1 Have you tried it in your workflow?
Are you getting expected result in day?

13

ya i have done manually , it didnot help

14

@Ananya1

Check below post
https://forum.uipath.com/t/tutorial-how-to-calculate-difference-between-two-time-values-using-uipath/247565/3

Mark as solution if this helps

Thanks