Convert date to dd/mm/yyyyy

Help
3

Fine
hope this expression would help you
if we are iterating through excel with read range activity and using a for each row loop then
inside the loop use a assign activity like this
str_datevalue = Datetime.ParseExact(row(“yourcolumnname”).ToString.SubString(0,10),“MM/dd/yyyy”,system.globalization.CultureInfo.InvariantCulture).ToString(“dd.MM.yyyy”)

now the string variable str_datevalue output would be in format dd.MM.yyyy

Cheers @kuzinyd