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
How to convert dd-MMM-yy to yyyy.MM.dd format? Studio studio , question , activities_panel	10	2940	September 20, 2022
Change format date excel Activities excel , activities , question	17	234	May 30, 2024
Converting date format in an excel cell into another date format Help excel , activities , question	13	2451	December 15, 2019
Want date format from excel in a desired type of date format Studio studio , question , immediate_panel	23	915	May 29, 2023
Convert column in Excel to dd/MM/yyyy Studio studio , question , activities_panel	7	77	May 6, 2025

Error in Date Format

Related topics