date and time difference b/w 2 dates

[venkat basa]

HI RPA gurus,

i want to find the time difference b/w 2 date and time,
eg: var1=2july2018 10:30:12

var2=3july2018 11:25:14

i want time difference(var2-var1),

Please help me

Regards,
Venkat

 

[Sukesh Kumaru]

Well, you can check with the System Variables available in AA,
or else go with the help of macros.

 

[venkat basa]

Thanks Sukesh,
i got idea to deal with two dates differences,using excel function we can get the difference
FYR.. PFB link
https://www.ablebits.com/office-addins-blog/2015/06/24/calculate-time-excel/

Thanks
Venkat

 

[Kumar987]

Hi,
Better approach to write a vbscript and pass parameter. You can calculate date difference in script and return.

Thanks

 

[VJR]

HI RPA gurus,

i want to find the time difference b/w 2 date and time,
eg: var1=2july2018 10:30:12

var2=3july2018 11:25:14

i want time difference(var2-var1),

Please help me

Regards,
Venkat

Hi venkat basa, you can make use of the available bot from the botstore.
https://botstore.automationanywhere.com/bot/change-date-and-time-format/
Under the features section refer to one of the operations called 'find date difference'.