Paste copy value in format "dd.MM.yyyy"

[teslyak9437 (Sam)]

How to copy a table with the following dates

and paste it into the following format

[lrtetala (Lakshman Reddy)]

Hi @teslyak9437

Try this

DT.AsEnumerable.ToList.ForEach(Sub(r)
    r(0)=r(0).ToString.Split(" "c).First()
End Sub
)

Output:

Cheers!!

[teslyak9437 (Sam)]

how to implement it on StudioX

[ashokkarale]

@teslyak9437,

Don’t need to copy paste the date. You can use Format Cells activity like this in StudioX

File Before Run:

Output:

Thanks,
Ashok