Covert column in specific date format

[Lakshya_Garg2 (Lakshya Garg)]

Hi Team,

today’s query is that I have a column which contains some date like format dd-MM-yyyy

now I have to convert that whole column in specific date format using linq.

required format : MM/dd/yyyy

pleae help me because this process already running in production.

[lrtetala (Lakshman Reddy)]

Hi @Lakshya_Garg2

Use this in Invoke Code activity

dt.AsEnumerable().ToList().ForEach(Sub(row) row("DateColumn") = DateTime.ParseExact(row("DateColumn").ToString(), "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("MM/dd/yyyy"))

Regards,

[pradeep931 (Pradeep Bandharam)]

Hi @Lakshya_Garg2

Please refer the below thread

Is it possible to convert a column format date MM/dd/yyyy to dd/MM/yyyy faster

Hi Yeah it can be with this expression stroutput = Datetime.ParseExact(Strinput.ToString, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”) And while merging make sure you have both the datatable having dates in same format and when written to excel it actually changes the format To avoid that use a for each row activity and pass datatable dt as input Inside the loop use a assign activity like this CurrentRow(“date ColumnName”) = “ ‘ “+ CurrentRow(“da…

[lrtetala (Lakshman Reddy)]

@Lakshya_Garg2

Another approach

Regards,

[singh_sumit (Sumit Singh Tariyal)]

Hie @Lakshya_Garg2 use this method
input

process

inside for each use this to store the column value

and use this logic to converted your date time

in the last on the code change (“yyyy-MM-dd”) to (“MM/dd/yyyy”) so you get your desired output
cheers Happy Automation

[Lakshya_Garg2 (Lakshya Garg)]

Hi,

thanks for the help but this is not working

[lrtetala (Lakshman Reddy)]

@Lakshya_Garg2

Can you please share the sample excel file

Regards,

[Lakshya_Garg2 (Lakshya Garg)]

Samplefile.xlsx (15.8 KB)

please find attached sample file

[lrtetala (Lakshman Reddy)]

@Lakshya_Garg2

Output:

Regards,

[Lakshya_Garg2 (Lakshya Garg)]

I try this solution and let you know, is it working or not