Hello. I am facing an error while converting date formats to a preferable date format for my process. The date format of the variable I receive is dd/MM. I get the date I want to convert from a data table named “out_dt_excel” and I store it to the variable “CurrentDate”. In the next assign activit…

Hi @aikaterini.karakasidi Issue is29/02 fails because no year is provided, and leap year validation is required. Try this, CurrentDate = CurrentDate & “/” & Now.Year ParsedDate = DateTime.ParseExact(CurrentDate, “dd/MM/yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyy…

How to fix date conversion error?

Help Activities

aikaterini.karakasidi (Aikaterini Karakasidi) March 17, 2025, 7:16am 4

You are both right. I didn’t check that the code was applying the dates of the current year and that’s why I had this issue.

I solved it by replacing indeed 2024.

Thank you for your time and comments.

1 Like

Topic		Replies	Views
Convert 01012020 date format to 01-01-2020 Activities datatable , excel , activities , error	10	2774	November 28, 2020
Not recognized as a valid date time Studio datatable , excel , activities , studio , question , activities_panel	2	388	March 23, 2023
Date conversion error Studio	14	1487	March 17, 2020
Convert Date in Datatable Activities database , activities , question	13	3683	March 2, 2022
Date showing in excel and in the data table are different and needs conversion Activities datatable , uiautomation , activities , error	5	1735	March 24, 2021

How to fix date conversion error?

Related topics