How to convert String to Date and Insert in DB

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

Hi @AaronMark,

Please check this link

Thanks!

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.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.