Input date format conversion

Hello. I have a column which contains dates as in the format ‘01/30/2023’ but I need to convert all dates to ‘30/01/2023’ format. How to do this? Thanks in advance.

try

(cdate(row(“ROW NAME”)).tostring(“dd/MM/yyyy”)

1 Like

Hi @Jnanesh_Ballal

You can use the following query to perform the date format conversion:

in_dt.AsEnumerable.ToList.ForEach(Sub(row) row(“DateColumnName”) = DateTime.ParseExact(row(“DateColumnName”).ToString,“MM/dd/yyyy”, Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”))

Best Regards.

1 Like

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