Question

Insert the latest date in excel and bot run time into an Excel

  • 28 September 2022
  • 1 reply
  • 4 views

Hi All,

 

Can someone suggest how to approach this scenario?

 

I have an Excel templet it contains two columns (Date, Time)Where I need to insert the Bot running date and time(As per the bot running time)

imageCan someone help me with this scenario(If possible any screenshot)...Thanks in advance


1 reply

Userlevel 4
Badge +8

Hello @KOLI CHARAN​ 

 

Thank you for posting in the Automation Anywhere user community forum!

 

Based on the description, we have suggested a bot logic below that can help achieve the use case. We hope this provides more clarity and information to get you going!

 

  • Try using the System Variables package to assign the current date and time to a user-defined variable when the bot runs. This will ensure that the time when the bots is run is captured into a user-defined variable

Product documentation: https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/using-variables/cloud-using-variables.html

 

  • Once the above steps are performed, please use the user-defined variable to write to the Excel file

 

Still, have doubts or need further clarifications? Please use the below link to create a Support Case and we will be glad to get in touch and assist further!

 

How to create a support case :

https://apeople.automationanywhere.com/s/article/How-to-Open-a-Support-Case

 

If you don't have access to the link, please email the AA Support team "apeopleopsteam@automationanywhere.com" to request access.

 

Kind Regards,

Jigar Solanki 

Automation Anywhere 

Reply