Convert 1d array of dates to a single string, changing format

[JavRR]

I import from excel the following table:

Vencimento
3/23/2022 0:00
3/24/2022 0:00
3/25/2022 0:00

When imported it is detected as datetime. And I want to save all the values into a single string variable, with format dd/MM/yyyy and separated bi semicolons, like this:
variable = “23/03/2022;24/03/2022;25/03/2022”

[ppr (Peter Preuss)]

give a try:
Assign Activity

strFlatten =

String.Join(";", YourDataTableVar.AsEnumerable.Select(Function (x) CDate(x(ColNameOrIndex).toString).toString("dd/MM/yyyy")))

[JavRR]

Thanks ppr!! It worked fine!!!
Marked as solution