Skip to main content
Question

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

  • September 28, 2022
  • 1 reply
  • 29 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

Forum|alt.badge.img+12

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 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings