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.
 

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.

 

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
 

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