Skip to main content
P
Pra_1
February 23, 2022
Question

"An exception occurred while parsing the date time" in the course "Implementing Back Office Automation Using AARI

  • February 23, 2022
  • 12 replies
  • 1498 views

While I was following the steps in the training course on "Implementing Back Office Automation Using AARI", I got this error "An exception occurred while parsing the date time". I tried to change the date format for the "Datetime: Assign" and also the datetime in the "If" condition, but I still encountered the same error.

 

I read from other posts that a "Datetime: To String" action might be needed, but I'm unsure how to make it work or if it's even needed for this case.

 

I have attached all the relevant screenshots for this task bot below.

    12 replies

    Show previous replies
    D
    Dwarkesh Swarnkar
    Cadet | Tier 2
    July 18, 2023

    Strange, am facing the same issue and Excel close action is already out of Loop action. Attached snap.

    Can anyone help on this? 

    S
    Shivi 2496
    Cadet | Tier 2
    July 11, 2024

    Hi,

    I am getting error : exception occurred while parsing the datetime.

    Flow : Opening the excel sheet, reading the data into the data table, running the loop for each row of the data table. the using Date time assign action to custom format : M/d/yyyy for rExcelRecord[12]

    Issue : The code is running fine if the data in the excel sheet is more than 6 rows but when I remove the data from excel and keep only 2 rows then it is throwing this error. Which is really very weird.

    Could anyone help.
     

    Terms & ConditionsAccessibility statement