Data column into Date type and sort from newest to oldest

[hp321 (hp)]

Hi,
I’m using this code in assign:

I get an error:

Can anyone please advise?
Thank you

[Shiva_Nikhil]

@hp321

in place of “MM/dd/yyyy”

use this

{"MM/dd/yyyy hh:mm:ss","MM/dd/yyyy","dd/MM/yyyy"}

[hp321 (hp)]

@Shiva_Nikhil

{"MM/dd/yyyy hh:mm:ss","MM/dd/yyyy","dd/MM/yyyy"}

thanks @Shiva_Nikhil ,
Now I don’t get an error,but the first date I get is 2019…there are more recent dates…
Please advise

[Shiva_Nikhil]

@hp321

can you try this

(From r In dt.AsEnumerable
Order By datetime.ParseExact(r("ColumnName").ToString.Trim,{"MM/dd/yyyy hh:mm:ss","MM/dd/yyyy HH:mm:ss","dd/MM/yyyy"},system.Globalization.CultureInfo.InvariantCulture).Date 
Descending 
Select r).CopyToDataTable

[Mariemily_Silva]

Hello!

Can you try this? please.

dt.AsEnumerable.OrderByDescending(Function(r) DateTime.ParseExact(r(“ColumnName”).ToString().Trim,
{“MM/dd/yyyy hh:mm:ss”, “MM/dd/yyyy HH:mm:ss”, “dd/MM/yyyy”},
CultureInfo.InvariantCulture).Date).CopyToDataTable

[ppr (Peter)]

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues

This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in hurry: Example Assignment Following Excel data will be processed and the corresponding Quarter is to calculate for the particular task date Input data: [input_raw] Quarter Calculation Quarter = CInt(Math.Ceiling(YourDateTimeVar.Month / 3 )) Initial Implementation [initial_flow_raw] tmpTaskDate = DateTime.ParseExact(row("Date").toString.Trim, "dd.MM.yyyy", Culture…

[hp321 (hp)]

Thanks @Shiva_Nikhil !
I just changed the last time expression to display the month first

[hp321 (hp)]

Thanks Mariemily Silva for your help

[hp321 (hp)]

Thanks @ppr for your help