Reading large csv file and need to change the date formats on output

[prasath17 (Guru)]

@jose.a.silvestre - You can invoke code, as shown in this post…this would be efficient and does not use For each…

Convert dd/MM/yyyy HH:mm:ss to 'yyyy-MM-dd'T'HH:mm:ss.fff'Z'

@ranjani - Check this below workflow… [image] Build Datatable [image] Invoke Code dtSample.AsEnumerable().ToList().ForEach(Sub(row) row(“DatefffZ”)=DateTime.ParseExact(row(“DatefffZ”).ToString,“yyyyMMddHHmmss.fff”,System.Globalization.CultureInfo.InvariantCulture).ToString(“yyyy-MM-ddTHH:mm:ss.fffZ”)) Invoke Code Edit Arguments [image] Output: [image] Hope this helps…

Note: you just have to tweak the date formats as per you need…