Quarter Start And End Dates

Set the start and end dates of the last quarter to the clipboard. The start date and end date are separated by commas.

Top Benefits

  • Just add one command to the bot you created
  • By simply executing the bot, you can get the start date and end date of the latest quarter.
  • The data is set on the clipboard for easy editing.
  • Creating logic is not required.

Tasks

  • When the task starts, the current date is calculated.
  • Gets the start date and end date of the last quarter's closing date 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.

Input and Trigger:
(1)Run the bot using the Run Task command on the bot you created.
(2)A message box will appear at the start of the process.
(3)At the end of the process the result will be displayed in the message box for only 2 seconds.

Action:
(1)The bot calculates the first and last day of the last quarter. Calculate the first and last day of the different quarters according to today's day.
・ January 1 and March 31
・ April 1 and June 30
・ July 1 and September 30
・ October 1 and December 31

(2)For example, if today is March 13, 2020, calculate the values ​​for October 1, 2019 and December 31, 2019.
If today is April 3, 2020, the values ​​for January 1, 2020 and March 31, 2020 are calculated.

Output:
(1)Set the date of the first and last days of the latest quarter 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. They are separated by commas.

yyyymmdd, yyyymmdd
For example, 20200101,20200331

(3)For the value set to the clipboard, execute the Sub String command of String Operation 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 quarterly settlement and help you to enter the information into business systems.
(2)The bot will not let you calculate the date of quarterly settlement.

Get Bot

Free

Bot Security Program
Level 1
Applications
Business Process
Category
Downloads
19
Vendor
Automation Type
Bot
Last Updated
July 24, 2020
First Published
March 15, 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