Change data table column format to yyyy/MM/dd

[oshan (Oviya S)]

Hi friends

I need to change the data table column format from text to date yyyy/MM/dd.

i tried below for each assign. its not working . any idea ?

row(1)= cdate(row(1)).ToString(“yyyy/MM/dd”)

i tried below one too . No luck
(From row In PLOutDt.Select Order By Convert.ToDateTime(row(1)) Ascending Select row).ToArray.CopyToDatatable()

[kommijeevan (Jeevan Kommi)]

Hi @oshan

Try this one

CDate(row(“Your Date”).Tostring).Tostring(“yyyy/MM/dd”)

Regards,
Kommi Jeevan

[kommijeevan (Jeevan Kommi)]

Cheers @oshan if you find it useful mark it as solution and close the thread.

[oshan (Oviya S)]

@kommijeevan

CDate(row(“Your Date”).Tostring).Tostring(“yyyy/MM/dd”)

@kommijeevan …thanks, but i am getting error as below.

[kommijeevan (Jeevan Kommi)]

change the data type and try

[oshan (Oviya S)]

@oshan

row(1)

i changed as below and tried, still failed,
sorry, do you have the code