Change format column from "General" to "Date"

@LZlz - Please check this post…

For your case, please use the below code in the Invoke code and Pass dtdate as in/out datatable variable in the “Edit Arguments”…

 dtdate.AsEnumerable().ToList().ForEach(Sub(row) row("YourColumnName")=Datetime.ParseExact(Datetime.FromOADate(cdbl(row("YourColumnName"))).ToString("M/d/yyyy"),"M/d/yyyy",CultureInfo.InvariantCulture))
1 Like