How to change the date format in Data Table

Hello everyone

Need to change this format : dd.MM.yyyy to yy/MM/dd

Variable = ExtractDataTable.rows(0)(“Date item”).ToString

Hi @Marian_B

Use for each row in datatable

then Assign Activity

LHS ->CurrentRow(“Date Piece”)

RHS → DateTime.ParseExact(row("Date Piece ").ToString,dd.MM.yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“yy/MM/dd”)

Regards
Gokul

2 Likes

Thanks Its worked @Gokul001

1 Like

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