Filter By date in Excel in the same sheet

[panpan1020 (AngPue)]

Hello!!!

Today, im trying to filter by date In Excel in the same sheet Using this LinQ:

(From z In DT1 Where Not String.IsNullOrEmpty(z(18).ToString) And Convert.ToDateTime(z(18).ToString) > Date.Now.AddDays(-41)Select z).CopyToDataTable

The date is in the column 19 BUt is returning this message:

The string was not recognized as a valid DateTime. There is an unknown word starting at index 0

How can i improve this LinQ??

[Vivek_Arunagiri]

What is the format of date in z(18) ?

[panpan1020 (AngPue)]

Mr. @Vivek_Arunagiri Hi

The format is: YYYY-MM-DD

[Vivek_Arunagiri]

Then use (From z In DT1 Where Not String.IsNullOrEmpty(z(18).ToString) And DateTime.ParseExact(z(18).tostring, “yyyy/MM/dd”,System.Globalization.CultureInfo.InvariantCulture) > Date.Now.AddDays(-41)Select z).CopyToDataTable

[panpan1020 (AngPue)]

@Vivek_Arunagiri

(From z In DT1 Where Not String.IsNullOrEmpty(z(18).ToString) And DateTime.ParseExact(z(18).tostring, “yyyy/MM/dd”,System.Globalization.CultureInfo.InvariantCulture) > Date.Now.AddDays(-41)Select z).CopyToDataTable

Now show me this error Assign: String was not recognized as a valid DateTime
And tell mi that Expected an ‘)’ i’m gonna try find a solution for that ‘)’ … what do you thinks Mr.Vivek?

[Vivek_Arunagiri]

Got it… you need to give “-” instead of “/”

(From z In DT1 Where Not String.IsNullOrEmpty(z(18).ToString) And DateTime.ParseExact(z(18).tostring, “yyyy-MM-dd”,System.Globalization.CultureInfo.InvariantCulture) > Date.Now.AddDays(-41)Select z).CopyToDataTable

[panpan1020 (AngPue)]

It keep showing an " ‘)’ Expected"

Im searching for the ‘)’ to put it…maybe in the where

Thanks for always reply!!!
Regards

[Vivek_Arunagiri]

@Vivek_Arunagiri

(From z In DT1 Where Not String.IsNullOrEmpty(z(18).ToString) And DateTime.ParseExact(z(18).tostring, “yyyy-MM-dd”,System.Globalization.CultureInfo.InvariantCulture) > Date.Now.AddDays(-41)Select z).CopyToDataTable

Try

(From z In DT1 Where (Not String.IsNullOrEmpty(z(18).ToString) And DateTime.ParseExact(z(18).tostring, “yyyy-MM-dd”,System.Globalization.CultureInfo.InvariantCulture) > Date.Now.AddDays(-41)).Select(z).CopyToDataTable

[panpan1020 (AngPue)]

Nope, now i hate the YYYY-MM-DD format jaja.

[nadim.warsi]

@Vivek_Arunagiri

(From z In DT1 Where Not String.IsNullOrEmpty(z(18).ToString) And DateTime.ParseExact(z(18).tostring, “yyyy/MM/dd”,System.Globalization.CultureInfo.InvariantCulture) > Date.Now.AddDays(-41)Select z).CopyToDataTable

its missing the first “(” close “)”
Guess its supposed to be like this
(From z In DT1 Where (Not String.IsNullOrEmpty(z(18).ToString) And DateTime.ParseExact(z(18).tostring, “yyyy-MM-dd”,System.Globalization.CultureInfo.InvariantCulture) > Date.Now.AddDays(-41)).Select(z)).CopyToDataTable