Struggling with Dates in bot using Automation Anywhere Community Edition

@anjelics. Could do it with Excel formulas after making sure the specific column of dates is formatted as dates. B2 | =A2<=(TODAY()-9)

Thank you Steven440, but I was hoping to build a bot that could do it, and not have it be an exercise done in excel.  Just to show a quick concept to my boss about what a bot could do.

Hi @anjelics ,

You can use the Datetime package for the same and use the Subtract action from it. Select Time value to subtract as 9 and select Days from Time unit to subtract drop-down list. Later on, convert this to a string variable using Date to String action and use that to compare with your excel data.

Thank you @Padmakumar.  I have this in one of my steps, but seems like I'm doing something wrong.
And I think the issue lies somewhere in the first step.
 

anjelics wrote:

Thank you @Padmakumar.  I have this in one of my steps, but seems like I'm doing something wrong.
And I think the issue lies somewhere in the first step.
 

 

 

 

 

Are you getting any error while executing this BOT?

Yes, I am.

 

anjelics wrote:

Yes, I am.

 

 

You are referencing the Column index in wrong format. 

If you are using index to fetch the data, then use $Record[IndexNumber]$ format.

If you are using the column name to fetch the data, then use $Record{ColumnName}$ format.

Thank you.  I took your suggestion.  Now I get this error
 

anjelics wrote:

Thank you.  I took your suggestion.  Now I get this error
 

 

Check what is the format showing for the System variable CurrentDate. Mention the same format in line 4 under Custom format portion. Otherwise, you will get the same error. If you need, later on, you can specify the date format which you actually want while converting the date time variable to String.

@anjelics ,

Set in a message box the output from Excel[7].

Let us know the result.

Regards

This is what the message box returns for Excel[7]
 

@anjelics 

Try to use the Custom Format dd/MM/yyyy when you assign the datatime variable.

HTH

Regards

Thank you for the suggestion, but I still get the same error :/

Have you checked date format showing for the System variable Date? You have to specify the same format.

I'm not quite sure how to do that.
I have built a simpler bot in the interim.

Convert the System variable Date to String and put it in a Message box and see what is the format you are getting there.

For me, the robot works OK¡¡ 🤗

Thanks @Padmakumar

MM/dd/yyyy
dd/MM/yyyy
dd-MM-yyyy

MM-dd-yyyy

I am getting the input date in the above mentioned formats. But I want to convert all the above formats to these format (dd-MMM-yyyy) using Automation Anywhere. I am able to handle one format at a time only, but I want to handle all these above mentioned formats at a time. Is it possible or not? If possible Please suggest me how to do.
Thank you 
Ashok Reddy