datetime difference between two dates in minutes

Question

In my pipeline, Iam having two variables (of type string) which is holding two different datetimestamp (UTC) . I want to know the difference between these two timestamps in minutes. Is it possible in Azure data factory?

Answer 1

Hello @r0909

You can use the tick function to work around this as we do not have an inbuild function get the time difference between two variable ( in mins ) .

You can use an expression like for one of the variables :

@string(ticks(variables('data1')))   

and

@string(ticks(variables('data2')))   

for the other . Since 1 tick = 100 nanosecond .
you can use the below expression to convert to mins :

@String(div(sub(int(variables('datediff2')),int(variables('datadiff'))),600000000))  

Please do let me know how it goes .

----------

Thanks Himanshu

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members