Hi to all, I collected with a scraping, this date, as a String. I should convert it to Datetime to upload it to the Database. [image] In the table, seconds are missing, so I would like to set all seconds = 00 ex: 2022-05-15 9:47:00 Can help me with this? :expressionless: Thanks Aaron

Hello, You can try this: DateTime.ParseExact(“12/05/2019 9.20”,“dd/MM/yyyy h.mm”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd-MM-yyyy hh:mm:ss”) Thanks! Athira

@AaronMark Check below for your reference [image] Convert String to Datetime Var Help @Sami_Syed String to DateTime: Date.ParseExact(yourStringVar, “d/MM/yyyy”,CultureInfo.InvariantCulture) ensure System.Globalization namespace is imported Increment Date (e.g. Add 1…

Thanks Athira. I had to tweak the string a little, but the hint was very helpful. DateTime.ParseExact(Data_Firma_PDA,“dd/MM/yyyy H.mm”,System.Globalization.CultureInfo.InvariantCulture).ToString(“yyyy-MM-dd HH:mm:ss”)

Help for convert String to Date

Help Studio

Srini84 (Srinivas Kadamati) May 17, 2022, 3:18pm 2

@AaronMark

Check below for your reference

Hope this may help you

Thanks

Topic		Replies	Views
Convert string to datetime, help Studio studio , question , activities_panel	3	621	September 30, 2023
Date time conversion to string and get only date in string format Studio studio , question , activities_panel	4	441	October 20, 2023
How to convert string to date time? Studio studio , question , find_references	10	5552	December 25, 2021
Convert String to Datetime Var Help activities , variable , string , question	2	5138	January 5, 2020
Convert String format of DateTime to Date format of DateTime Learning Hub question , data_manipulation	8	3905	July 30, 2020

Help for convert String to Date

Related topics