Inputs and triggers:
(1) Execute the bot using the task execution command with the created bot.
(2) A message box will be displayed at the start of the process.
(3) At the end of the process, a message box will show the result for only 2 seconds.
Action:
(1) The bot calculates the first day of the last 12 months and the last day of the last month. Calculates the first and last day of the last 12 months depending on today's day.
(2) For example, if today is March 13, 2020, calculate the values for March 1, 2019 and February 29, 2020.
Also, if today is April 2, 2020, the values for April 1, 2019 and March 31, 2020 will be calculated.
Output:
(1) Set the date of the first 12 months and the last day of the last 12 months on the clipboard. Set as follows:
(2) The first day is to the left of the value set on the clipboard. The right side is the last day of the last month. They are separated by commas.
yyyymmdd, yyyymmdd
For example, 20190301,20200229
(3) For the value set on the clipboard, execute the String String Sub String command to extract the value from the clipboard.
(4) If an error occurs, -1 is set to the clipboard.
Use Case:
(1) Calculates the first and last days required for input processing etc. for the last 12 months, and helps to enter information into the business system.
(2) The bot does not allow you to calculate the first day of the last 12 months and the last day of the last month.
Other:
Compatible with leap years.