Skip to main content
C
CharanKoli
Navigator | Tier 3
September 28, 2022
Question

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

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

    A
    Automation Anywhere Team
    Automation Anywhere Team
    Automation Anywhere Team
    September 30, 2022

    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 

    Terms & ConditionsAccessibility statement