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

Rahul_Rajendran (Rahul Rajendran) March 14, 2025, 2:51pm 3

It appears the code is trying to convert “29/02” into “29/02/2025,” which results in an invalid date.

What do you need in such cases? Would using 2024 as the year work for you?

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