How to filter between dates from string and datetimepicker

Question

1.00/5 (1 vote)

See more:

I am trying to filter through things by date. I have 2 DateTimePicker called FromDate and ToDate. I have an array and within one of the array (str[10]) is a date, I tried converting the string into a datetime format but I still get the error:

System.FormatException: 'String was not recognized as a valid DateTime.'

The string within str[10]:

str[10] = "9/22/2017 18:24";

What I have tried:

My current code:

string[] date = str[10].Split(' ');                            
DateTime dateSpec = DateTime.ParseExact(date[0], "MM/dd/yyyy", CultureInfo.CurrentCulture);
if (dateSpec >= FromDate.Value && dateSpec <= ToDate.Value) 
{ 
   //Do Something
}

I am not so sure what to do as most forums suggest more or less the same thing. I'm not sure where the error is. I checked the array and the string does not have any spaces as well, thinking that it may have been the reason as to why there was an error

Posted 7-Apr-22 21:30pm

Allysha April

Updated 7-Apr-22 21:47pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2022-04-07T21:43:00

Do NOT split string into parts! Use exact formats!

Try to use DateTime.TryParseExact Method (System) | Microsoft Docs[^]

See:

C#

string str10 = "9/22/2017 18:24";
string[] formats = {"M/d/yyyy HH:mm", "M/dd/yyyy HH:mm", "MM/d/yyyy HH:mm", "MM/dd/yyyy HH:mm"};

DateTime dateSpec = DateTime.Now;
if(DateTime.TryParseExact(str10, formats, System.Globalization.CultureInfo.CurrentCulture, System.Globalization.DateTimeStyles.None, out dateSpec))
  //process your date
else
  //problem in datetime conversion

OriginalGriff · Answer 2 · 2022-04-07T21:47:00

"MM/dd/yyyy" is a very specific date format: it matches only 2 character months (01 to 12) and two character day of months (01 to 31).
To match months or days that may or may not have a leading aero, use the shorter date form "M/d/yyyy"

This may help in future: Formatting a DateTime for display - format string description[^] - the format strings are the same for input and output.

How to filter between dates from string and datetimepicker

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0