Date changes when populated to excel sheet

While extracting an invoice date from an invoice sheet using OCR, the date changes from dd-mm-yy format to mm-dd-yyyy format while populating it to excel sheet.I could view the date via message box in the format dd-mm-yyyy but don’t know about this change. I have given data type for invoice date as String as i can’t find a valid datatype for data in the given format. Can anyone help to resolve this issue?

Hi @Gopalakrishnan_K

Check out the below thread for the same :-

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like



This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.