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 …

Hi @Gopalakrishnan_K Check out the below thread for the same :- [image] Date format is changed when writing the data in excel Help Hi @israelesd , After you write the excel you can change the format of the cell using the below activity. Video : [UiPath | How …

@Gopalakrishnan_K [How to Convert Date and Time Format using UiPath || RPA UseCase] Thanks

Date changes when populated to excel sheet

Help Studio

Pratik_Wavhal (Pratik Wavhal) August 3, 2020, 5:53am 2

Hi @Gopalakrishnan_K

Check out the below thread for the same :-

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

Topic		Replies	Views
Read Date from Excel Help excel	4	2786	September 18, 2019
Date format is changed when writing the data in excel Help excel , studio , question	3	2453	July 3, 2020
Excel: Data goes from dd/MM/yyyy to MM/dd/yyyy Studio datatable , excel , studio , question , activities_panel	9	7789	March 7, 2022
Incorrect date format Studio excel , studio	15	2825	February 7, 2021
Cambio de formato de excel a formulario Ask in Your Language studiox , question , spanish	4	159	December 3, 2024

Date changes when populated to excel sheet

Related topics