Date variables how to

[dc@abswebb.net]

I have a task that requires the filling in of variable dates. I need to fill in a date field in a program that runs a report. I want to run this task once per month on the 5th day of the month, and I want the begining date field in the program to be filled in with the first day of last month, then the ending date field in the program to be filled in with the last day of last month.

Any help please send suggestion to dc@abswebb.net

Thanks,

[forumsupport]

Hello,

Using Automation Anywhere 4.0, you can perform this task very well. Automation Anywhere provides various System variables that can be used to get the current day, month, year, date and time. They are $Date$, $Year$, $Month$, $Day$, $Hour$, $Minute$ and $Second$. You can use the combination of any of the above variables to get date format of your choice. In addition, you can perform calculations on them to get start and end date of last month. You can use Variable Operation command to work with the variable assignment.

For your convenience, we have attached sample task (GetStart&EndDate4LastMonth.atmn). Copy it under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.
Before running this task, you will have to create three variables namely, StartDate, EndDate and LastDay. Please follow below mentioned steps to create a variable “LastDay”.

1. Go to Tools->Variable Manager in Automation Anywhere.

2. Click on “Add New Variable”.

3. In “Name” field, enter “LastDay”.

4. In “Value” field enter any value say 'a'.

5. Press “Save”

6. Press “Ok” in Variable Manager window.

7. Similarly, create other two variables, StartDate and EndDate.

When you will run this task, it will show you start and end date of last month in message box.

Hope that helps.