Hi, I have an excel with date column, values as below. first one is in mm/dd/yyyy format and second one is in dd/mm/yyyy format 6/11/2020 16/06/2020 On fetching the column value using – Row.Item(“Date Of last contact”).ToString it shows - 06/11/2020 00:00:00 16/06/2020 When i do any kind of…

[image] Shuchi_Gupta: On fetching the column value using – Row.Item(“Date Of last contact”).ToString it shows - 06/11/2020 00:00:00 16/06/2020 Hi @Shuchi_Gupta , As Inpsected by checking the date values, we observe two types of date formats. dd/MM/yyyy MM/dd/yyyy HH:mm:ss We would need …

Hi @Shuchi_Gupta How about this expression? DateDiff (DateInterval.Day,DateTime.ParseExact(Row.Item(“Date Of last contact”).ToString,"dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy"),DateTime.now.Tostring(dd/MM/yyyy)).ToString Regards Gokul

@rohith.prabhu - i believe this wont work as date is in different format in excel. while fetching Row.Item … it will come in different format and we need to give the exact format in DateTime.ParseExact(Row.Item(“Date Of last contact”).ToString,“dd/MM/yyyy”, Correct me if I am wrong.

Hi @Shuchi_Gupta - we can pass multiple formats in the same expression as below to cover all possible formats appearing in the input DateContacted = DateTime.ParseExact(Row.Item(“Date Of last contact”).ToString,{“dd/MM/yyyy”, “MM/dd/yyyy HH:mm:ss”},System.Globalization.CultureInfo.InvariantCulture…

Hi @Shuchi_Gupta How about this expression ? ArrString → Array(String) format ArrString = New String(){"MM/dd/yyyy","dd/MM/yyyy hh:mm:ss","MM/dd/yyyy hh:mm:ss","dd/MM/yyyy"} DateDiff (DateInterval.Day,DateTime.ParseExact(Row.Item("Date Of last contact").ToString,ArrString,System.Globalization.Cu…

[image] supermanPunch: As Inpsected by checking the date values in addition to @supermanPunch also find following firstAid sheet introducing to this topic and also showing analysis techniques :ambulance: :sos: [FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTi…

@supermanPunch Thanks. It worked.

DateTime Manipulation - String was not recognized as a valid DateTime

Help Studio

RK_0 (RK) August 11, 2022, 6:00am 2

Hi,

Can you try with this
int_days = DateDiff(DateInterval.Day, DateTime.ParseExact(Strinput.ToString, “dd-MMM-yyyy”, System.Globalization.CultureInfo.InvariantCulture),DateTime.now())

Change format as per your input string,

Refer this for datetime

Topic		Replies	Views
Change Format DateTime Studio studio , question , variables_management	10	1129	February 23, 2024
Error message: Assign: String was not recognized as a valid DateTime Studio studio , question , activities_panel	10	1231	April 4, 2023
How to convert a string to date Studio datatable , excel , orchestrator , studio , question , activities_panel	13	1738	December 12, 2022
String is not recognized as a valid datetime - MM/dd/yyyy format is only working Studio activities , studio , question , date , datetime	8	12423	April 18, 2022
String was not recognized as a valid DateTime Conversion problem Studio datatable , excel , robot , studio , question , variables_management	2	2424	January 5, 2022

DateTime Manipulation - String was not recognized as a valid DateTime

Related topics