Hey guys, I have that strange problem from couple of days. When I read/write in UIPath Studio xls to xlsx, the columns with dates swap the dd with MM when dd is <= 12. If it is above 12 it keeps the format I want dd/MM/yyyy. Have you ever encountered that problem? And how did you fix it. Regards, …

row(“Date_col_Name”) = DateTime.ParseExact(row(“date_column_name”).ToString,“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture) sorry add .ToString

UiPAth swaps day with Month

Help

Phoenixxx (Phoenixxx) June 27, 2019, 1:26pm 4

Hey @ashley11

How should I use you method. For each thrue every cell?

Topic		Replies	Views
Uipath reads the data from excel in MM/dd/yyyy Format, but the value is in dd/MM/yyyy Studio studio , question , activities_panel	5	435	November 4, 2023
Excel date format is changing from dd/MM/yyyy to MM/dd/yyyy Studio studio , question , activities_panel	11	2024	August 1, 2022
Date Format in Excel Reading Activity Help studio	6	9209	December 6, 2022
Dummy needs help: how do i make uipath studioX write the date in the correct ddmmyyyy format into excel? StudioX studiox , question	1	889	April 27, 2022
Date conversion issue using uipath Studio studio , question , activities_panel	46	484	February 18, 2025

UiPAth swaps day with Month

Related topics