How to convert String to Date and Insert in DB

[AaronMark]

Hi,
I have a problem with the conversion of a data collected from the Web, for insertion in DB.

In my flow, I created a table with the Date column, at the moment, Varchar.
I would like to collect this data as a datetime, because it is needed for a later verification.

I tried to get the first 10 characters of the string.
Then I tried the Convert.todatetime … dd-MM-yyyy but this doesn’t seem to be ok.

what am I doing wrong?
is there a better way to get this value as a date?

Thanks
Aaron

[kadiravan_kalidoss (Kadiravan K)]

Hi @AaronMark,

Convert a string to date

fine is 12/05/2018 is of format dd/MM/yyyy or MM/dd/yyyy if its dd/MM/yyyy then out_date = Datetime.ParseExact(“12/05/2019”,“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture) where out_date is a variable of type datetime or if its of format “MM/dd/yyyy” then out_date = Datetime.ParseExact(“12/05/2019”,“MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture) Cheers @mz3bel

Please check this link

Thanks!

[AaronMark]

Thanks kadiravan.
I tried to use a similar string, but it returned an error.
I used yours … now it seems to work fine.
Thanks so much
Very kind.