Two-digit Month, Day, etc.

[sfgsvp]

Is it possible to get a two-digit number for the month, day, hour, minute, second system variables. For example, I would like to build today's date as "D20080227" in the format: "DYYYYMMDD", but what I get instead is: "D2008227".

The same goes for the other fields I listed where less than 10 is a possiblity.

Thanks.

[forumsupport]

Hello,

In that case you can insert 'If' command to check if $Day$ or $Month$ is less then 10 and inside 'If' use 'Variable Operation' command to append 0 to $Day$ or $Month$ .
For your convenience, we have created one sample task (2DigitDayorMnth.atmn). Copy it under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.

Before running this task create 2 variables namely, $UDay$ and $UMnth$ through Tools->Variable Manager.

To create variable please follow below mentioned steps,

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

2. Click on “Add New Variable”.

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

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

5. Press “Save”

6. Press “Ok”

7. Similarly, create $UMnth$ variable.

In addition, you can also configure format of $Date$ system variable from Tools->Variable Manager->System Variable->Date. Click on '...' button and select format from list.

Hope that helps.

[Pulse]

What I did was to write a small Javascript that returns the date for me.

The attached script takes the current date minus(-) 1 day(iow yesterday) and returns a date.

[rlaliberte]

And how are you using this script?

I have had issues working with dates... did not care for the whole open Excel work around; never did get a way to pull the system date and then use it for a task.

[forumsupport]

Hello,

You can use 'Run Script' command to run .vbs or .js script. You can find this command under Tasks/Scripts command category.

[rlaliberte]

Obviously I have been missing something for the last year or so... I never knew about these system variables, where I could pull the date.

How is the reformatted date returned to the task?

[forumsupport]

Hello,

Using Run Script command,

. You can run other VB Scripts (*.vbs) or JScripts (*.js) from a task.
. You can also pass parameters to your scripts.
. There is also an option to specify the return value in your scripts.

[rlaliberte]

Originally Posted by forumsupport

Hello,

. There is also an option to specify the return value in your scripts.

Where is this option?

[forumsupport]

Hello,

Attached is the screenshot of Run Script command showing option to specify return value.

[rlaliberte]

What version is this available in?

Does not seem to be available in my version.