First And Last Days Of Last 6 Months

Set the first and last 6 months in the clipboard. The first and end dates are separated by commas.

Top Benefits

  • Just add one command to the bot you created
  • Set the first day and the last day of the last 6 months on the clipboard. The first and end dates are separated by comma
  • The data is set on the clipboard for easy editing.
  • Creating logic is not required.
  • Compatible with leap years.

Tasks

  • When the task starts, the current date is calculated.
  • Gets the start and end dates of the last 6 months from the current date.
  • When the task is completed, set the acquired data to the clipboard
  • The start date and end date are separated by commas.

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 six months and the last day of the last month. Calculates the first and last day of the last 6 months, depending on today's day.

(2) For example, if today is March 13, 2020, calculate the values ​​for September 1, 2019 and February 29, 2020.
Also, if today is April 2, 2020, the values ​​for October 1, 2019 and March 31, 2020 will be calculated.

output:
(1) Set the date of the first and last days of the last 6 months to 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, 20191001,20200331

(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) Calculate the first and last days required for input processing etc. for the last 6 months, and help to enter information into the business system.
(2) The bot does not allow you to calculate the first day of the last six months and the last day of the last month.

Other:
Compatible with leap years.

Get Bot

Free

Bot Security Program
Level 1
Applications
Business Process
Category
Vendor
Automation Type
Bot
Last Updated
March 23, 2020
First Published
March 23, 2020
Enterprise Version
11.3.1
ReadMe
ReadMe
Support

See the Bot in Action

bot program whole
bot execution example (specify bot with 'Run Task' comm
Message box to start execution of bot
bot execution result
PREV NEXT
bot program whole
bot execution example (specify bot with 'Run Task' comm
Message box to start execution of bot
bot execution result

Setup Process

Install

Download the Bot and follow the instructions to install it in your AAE Control Room.

Configure

Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)

Run

That's it - now the Bot is ready to get going!

Requirements and Inputs

  • Add the Run Task command to the bot you created and specify the bot
  • The value is set on the clipboard. yyyymmdd, yyyymmdd
  • Get the value from the clipboard and use it for various purposes