To All Who Are Willing to Help: I had this column in my generated report “PR Creation Date” and contained thousands of rows (~7k rows). I wanted to automate the date format of this column cells containing “dd-MMM-yy” format but there was an error in its current state. Message Error shown: *This cel…

Hi, Can you try the following sample? [image] dt.AsEnumerable.ToList.ForEach(Sub(r) r("PR Creation Date") = r("PR Creation Date").ToString.Insert( r("PR Creation Date").ToString.LastIndexOf("-")+1,"20") End Sub ) Sample Sample20231004-4L.zip (9.3 KB) Regards,

Error in Date Format

Help Studio

Gokul001 (Gokul Balaji) October 4, 2023, 5:52am 2

HI @jharmel.carmona

Can you check out the thread

Regards
Gokul

1 Like

Topic		Replies	Views
Converting date format in an excel cell into another date format Help excel , activities , question	13	2449	December 15, 2019
How to convert dd-MMM-yy to yyyy.MM.dd format? Studio studio , question , activities_panel	10	2928	September 20, 2022
Excel Convert Row Value into Date Format Help datatable , excel	10	2510	September 22, 2019
Change Format in Excel (General to Date) Help	15	6843	September 22, 2019
Date format change in excel column Activities excel	29	6072	October 22, 2020

Error in Date Format

Related topics