Ling query not working

Help Activities
,
1

(From i In dt_CLDData.AsEnumerable()
Order By i(“Year”).ToString(),
i(“Quarter”).ToString(),
i(“Provider NPI”).ToString(),
i(“RX Number”).ToString(),
If(IsDBNull(i(“DOS”)), DateTime.MinValue,
If(IsNumeric(i(“DOS”)), DateTime.FromOADate(CDbl(i(“DOS”))), Convert.ToDateTime(i(“DOS”)))),
i(“Claim Number”).ToString(),
If(IsDBNull(i(“Payment Date”)), DateTime.MinValue,
If(IsNumeric(i(“Payment Date”)), DateTime.FromOADate(CDbl(i(“Payment Date”))), Convert.ToDateTime(i(“Payment Date”))))
Select i).CopyToDataTable()

This query doesn’t give proper output for Column DOS and Payment Date, below img for one column.
image

it is not converted to Date time.

2

Hi @Rakesh_Tiwari

What is your requirement of this linq expression.?

3

i am sorting all the column in the excel

4

can anyone give me the query for my requirement?

5

Hi @Rakesh_Tiwari

If it has to be converted to date time add one more assign after the your query

dt_final=(From row In dt_final.AsEnumerable() 
Select dt_final.Clone.LoadDataRow(New Object() { row("Year"), row("Quarter"), row("Provider NPI"), row("RX Number"),
If(IsDBNull(row("DOS")), "", If(IsNumeric(row("DOS")), DateTime.FromOADate(CDbl(row("DOS"))).ToString("dd-MM-yyyy"), CType(row("DOS"), DateTime).ToString("dd-MM-yyyy"))), row("Claim Number"),
If(IsDBNull(row("Payment Date")), "", If(IsNumeric(row("Payment Date")), DateTime.FromOADate(CDbl(row("Payment Date"))).ToString("dd-MM-yyyy"), CType(row("Payment Date"), DateTime).ToString("dd-MM-yyyy"))) }, False)).CopyToDataTable()

Hope this helps