i have this 01 Mo Aug kind horrible format date coulmn and my firend convetted it to DD/MM(Months in word) output is like ths 01Aug,02Aug, and so on The year is 2022 here is what he have done v_arr_ColumnName = v_dt_DB.Columns.Cast(Of DataColumn).where(function(col) System.Text.RegularExpre…

HI @indiedev91 Try with this expression DateTime.ParseExact("01Aug","ddMMM",System.Globalization.CultureInfo.InvariantCulture).ToString("MM/dd/yyyy") [image] Regards Gokul

How can i convert DD/MM(Months in Words) to MM/DD/YYYY format

Help Studio

Gokul001 (Gokul Balaji) November 24, 2022, 5:42am 11

Hi @indiedev91

Kindly close this topic by mark as solved it will help for other too.

Regards
Gokul

Topic		Replies	Views
Convert MM/DD/YYYY to DD/MM/YYYY Help	3	8093	August 29, 2019
Convert input string to mm/dd/yyyy Help studio , string , question , data_manipulation	6	1107	December 24, 2019
Convert "MM/dd/yy" to "dd/MM/yyyy" Help activities , string , question	11	5992	January 9, 2020
"dd MM yyyy" to dd/MM/yyyy Help	2	826	August 22, 2019
Conversion of Multiple Time formats into a single format Help	20	1759	January 27, 2020

How can i convert DD/MM(Months in Words) to MM/DD/YYYY format

Related topics