How can we calculate number of days between two dates.
Page 1 / 1
Hi
You can do either of the below 3 methods.
- Use a calendar table in a database
or
- Use VB/Java/python script
or
- Use Difference between two dates package from bot store.
Hope of this will help.
Hi
- Use below botstore package for a simple solution.
https://botstore.automationanywhere.com/bot/automation-360-difference-between-two-dates-package
- Checkout below tutorial to import the bot package from botstore.
- Search for DifferencebetweenTwoDates package from the Actions pane
-
You can retrieve the difference between two dates in days format by using the DifferenceBetweenTwoDates: Difference between two dates in Days command and provide the First Date and Second Date as well as the Date Format. The output should be assigned to a string variable as below
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.