Hello There, Guest!
View New Posts  |  View Today's Posts
[SOLVED] DateTime Parse

  • 0 Vote(s) - 0 Average


01-02-2014, 10:39 PM #1
Lee Stevens
Senior Member
***
Posts: 345 Threads:54 Joined: Feb 2012 Reputation: 12

DateTime Parse
Hi guys,

I'm trying to output a date sting back into a DateTime object

Code:
DateTime date;
            if (DateTime.TryParseExact("Monday 30 December - 04:50:01", "dddd dd MMMM - hh:mm:ss", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None, out date))
            {
                MessageBox.Show("True");
            }
            else
            {
                MessageBox.Show("False");
            }

It always returns false although the format is correct, any ideas?
This post was last modified: 01-09-2014, 09:34 PM by Lee Stevens.

01-02-2014, 11:28 PM #2
AceInfinity
Developer
*******
Administrators
Posts: 9,733 Threads:1,026 Joined: Jun 2011 Reputation: 76

RE: DateTine Parse
Yeah, add the year in there and see what happens:
Code:
DateTime date;
Console.WriteLine(DateTime.TryParseExact("Monday 30 December - 2013 04:50:01", "dddd dd MMMM - yyyy hh:mm:ss",
   CultureInfo.InvariantCulture, DateTimeStyles.None, out date)
   ? "True"
   : "False");

There are formats you need to follow: http://msdn.microsoft.com/en-us/library/...10%29.aspx

cheers
This post was last modified: 01-02-2014, 11:29 PM by AceInfinity.


Microsoft MVP .NET Programming - (2012 - Present)
®Crestron DMC-T Certified Automation Programmer

Development Site: aceinfinity.net

 ▲
 ▲ ▲

01-02-2014, 11:39 PM #3
Lee Stevens
Senior Member
***
Posts: 345 Threads:54 Joined: Feb 2012 Reputation: 12

RE: DateTine Parse
Haha, god - thank you Ace. Always something so simple!

EDIT: Would it be possible to use LINQ with the current format? So the where clause would be for instance "Monday 30 December 2013 - 00:00:00" To "Monday 30 December 2013 - 23:59:59"
This post was last modified: 01-02-2014, 11:47 PM by Lee Stevens.

01-03-2014, 12:34 AM #4
AceInfinity
Developer
*******
Administrators
Posts: 9,733 Threads:1,026 Joined: Jun 2011 Reputation: 76

RE: DateTine Parse
Iterative LINQ that selects the values 0-Limit for each #:#:# and concats/formats them into a string of the format you want above.


Microsoft MVP .NET Programming - (2012 - Present)
®Crestron DMC-T Certified Automation Programmer

Development Site: aceinfinity.net

 ▲
 ▲ ▲

01-03-2014, 12:39 AM #5
AceInfinity
Developer
*******
Administrators
Posts: 9,733 Threads:1,026 Joined: Jun 2011 Reputation: 76

RE: DateTine Parse
Example:
[code=csharp]var query = from int a in Enumerable.Range(1, 10)
from int b in Enumerable.Range(1, 10)
from int c in Enumerable.Range(1, 10)
select string.Format("{0}:{1}:{2}", a, b, c);

foreach (var obj in query)
{
Console.WriteLine(obj);
}[/code]

You could've also used SelectMany().

Code:
1:1:1
1:1:2
1:1:3
1:1:4
1:1:5
1:1:6
1:1:7
1:1:8
1:1:9
1:1:10
1:2:1
1:2:2
1:2:3
1:2:4
1:2:5
1:2:6
1:2:7
1:2:8
1:2:9
1:2:10
1:3:1
1:3:2
1:3:3
1:3:4
1:3:5
1:3:6
1:3:7
1:3:8
1:3:9
1:3:10
1:4:1
1:4:2
1:4:3
1:4:4
1:4:5
1:4:6
1:4:7
1:4:8
1:4:9
1:4:10
1:5:1
1:5:2
1:5:3
1:5:4
1:5:5
1:5:6
1:5:7
1:5:8
1:5:9
1:5:10
1:6:1
1:6:2
1:6:3
1:6:4
1:6:5
1:6:6
1:6:7
1:6:8
1:6:9
1:6:10
1:7:1
1:7:2
1:7:3
1:7:4
1:7:5
1:7:6
1:7:7
1:7:8
1:7:9
1:7:10
1:8:1
1:8:2
1:8:3
1:8:4
1:8:5
1:8:6
1:8:7
1:8:8
1:8:9
1:8:10
1:9:1
1:9:2
1:9:3
1:9:4
1:9:5
1:9:6
1:9:7
1:9:8
1:9:9
1:9:10
1:10:1
1:10:2
1:10:3
1:10:4
1:10:5
1:10:6
1:10:7
1:10:8
1:10:9
1:10:10
2:1:1
2:1:2
2:1:3
2:1:4
2:1:5
2:1:6
2:1:7
2:1:8
2:1:9
2:1:10
2:2:1
2:2:2
2:2:3
2:2:4
2:2:5
2:2:6
2:2:7
2:2:8
2:2:9
2:2:10
2:3:1
2:3:2
2:3:3
2:3:4
2:3:5
2:3:6
2:3:7
2:3:8
2:3:9
2:3:10
2:4:1
2:4:2
2:4:3
2:4:4
2:4:5
2:4:6
2:4:7
2:4:8
2:4:9
2:4:10
2:5:1
2:5:2
2:5:3
2:5:4
2:5:5
2:5:6
2:5:7
2:5:8
2:5:9
2:5:10
2:6:1
2:6:2
2:6:3
2:6:4
2:6:5
2:6:6
2:6:7
2:6:8
2:6:9
2:6:10
2:7:1
2:7:2
2:7:3
2:7:4
2:7:5
2:7:6
2:7:7
2:7:8
2:7:9
2:7:10
2:8:1
2:8:2
2:8:3
2:8:4
2:8:5
2:8:6
2:8:7
2:8:8
2:8:9
2:8:10
2:9:1
2:9:2
2:9:3
2:9:4
2:9:5
2:9:6
2:9:7
2:9:8
2:9:9
2:9:10
2:10:1
2:10:2
2:10:3
2:10:4
2:10:5
2:10:6
2:10:7
2:10:8
2:10:9
2:10:10
3:1:1
3:1:2
3:1:3
3:1:4
3:1:5
3:1:6
3:1:7
3:1:8
3:1:9
3:1:10
3:2:1
3:2:2
3:2:3
3:2:4
3:2:5
3:2:6
3:2:7
3:2:8
3:2:9
3:2:10
3:3:1
3:3:2
3:3:3
3:3:4
3:3:5
3:3:6
3:3:7
3:3:8
3:3:9
3:3:10
3:4:1
3:4:2
3:4:3
3:4:4
3:4:5
3:4:6
3:4:7
3:4:8
3:4:9
3:4:10
3:5:1
3:5:2
3:5:3
3:5:4
3:5:5
3:5:6
3:5:7
3:5:8
3:5:9
3:5:10
3:6:1
3:6:2
3:6:3
3:6:4
3:6:5
3:6:6
3:6:7
3:6:8
3:6:9
3:6:10
3:7:1
3:7:2
3:7:3
3:7:4
3:7:5
3:7:6
3:7:7
3:7:8
3:7:9
3:7:10
3:8:1
3:8:2
3:8:3
3:8:4
3:8:5
3:8:6
3:8:7
3:8:8
3:8:9
3:8:10
3:9:1
3:9:2
3:9:3
3:9:4
3:9:5
3:9:6
3:9:7
3:9:8
3:9:9
3:9:10
3:10:1
3:10:2
3:10:3
3:10:4
3:10:5
3:10:6
3:10:7
3:10:8
3:10:9
3:10:10
4:1:1
4:1:2
4:1:3
4:1:4
4:1:5
4:1:6
4:1:7
4:1:8
4:1:9
4:1:10
4:2:1
4:2:2
4:2:3
4:2:4
4:2:5
4:2:6
4:2:7
4:2:8
4:2:9
4:2:10
4:3:1
4:3:2
4:3:3
4:3:4
4:3:5
4:3:6
4:3:7
4:3:8
4:3:9
4:3:10
4:4:1
4:4:2
4:4:3
4:4:4
4:4:5
4:4:6
4:4:7
4:4:8
4:4:9
4:4:10
4:5:1
4:5:2
4:5:3
4:5:4
4:5:5
4:5:6
4:5:7
4:5:8
4:5:9
4:5:10
4:6:1
4:6:2
4:6:3
4:6:4
4:6:5
4:6:6
4:6:7
4:6:8
4:6:9
4:6:10
4:7:1
4:7:2
4:7:3
4:7:4
4:7:5
4:7:6
4:7:7
4:7:8
4:7:9
4:7:10
4:8:1
4:8:2
4:8:3
4:8:4
4:8:5
4:8:6
4:8:7
4:8:8
4:8:9
4:8:10
4:9:1
4:9:2
4:9:3
4:9:4
4:9:5
4:9:6
4:9:7
4:9:8
4:9:9
4:9:10
4:10:1
4:10:2
4:10:3
4:10:4
4:10:5
4:10:6
4:10:7
4:10:8
4:10:9
4:10:10
5:1:1
5:1:2
5:1:3
5:1:4
5:1:5
5:1:6
5:1:7
5:1:8
5:1:9
5:1:10
5:2:1
5:2:2
5:2:3
5:2:4
5:2:5
5:2:6
5:2:7
5:2:8
5:2:9
5:2:10
5:3:1
5:3:2
5:3:3
5:3:4
5:3:5
5:3:6
5:3:7
5:3:8
5:3:9
5:3:10
5:4:1
5:4:2
5:4:3
5:4:4
5:4:5
5:4:6
5:4:7
5:4:8
5:4:9
5:4:10
5:5:1
5:5:2
5:5:3
5:5:4
5:5:5
5:5:6
5:5:7
5:5:8
5:5:9
5:5:10
5:6:1
5:6:2
5:6:3
5:6:4
5:6:5
5:6:6
5:6:7
5:6:8
5:6:9
5:6:10
5:7:1
5:7:2
5:7:3
5:7:4
5:7:5
5:7:6
5:7:7
5:7:8
5:7:9
5:7:10
5:8:1
5:8:2
5:8:3
5:8:4
5:8:5
5:8:6
5:8:7
5:8:8
5:8:9
5:8:10
5:9:1
5:9:2
5:9:3
5:9:4
5:9:5
5:9:6
5:9:7
5:9:8
5:9:9
5:9:10
5:10:1
5:10:2
5:10:3
5:10:4
5:10:5
5:10:6
5:10:7
5:10:8
5:10:9
5:10:10
6:1:1
6:1:2
6:1:3
6:1:4
6:1:5
6:1:6
6:1:7
6:1:8
6:1:9
6:1:10
6:2:1
6:2:2
6:2:3
6:2:4
6:2:5
6:2:6
6:2:7
6:2:8
6:2:9
6:2:10
6:3:1
6:3:2
6:3:3
6:3:4
6:3:5
6:3:6
6:3:7
6:3:8
6:3:9
6:3:10
6:4:1
6:4:2
6:4:3
6:4:4
6:4:5
6:4:6
6:4:7
6:4:8
6:4:9
6:4:10
6:5:1
6:5:2
6:5:3
6:5:4
6:5:5
6:5:6
6:5:7
6:5:8
6:5:9
6:5:10
6:6:1
6:6:2
6:6:3
6:6:4
6:6:5
6:6:6
6:6:7
6:6:8
6:6:9
6:6:10
6:7:1
6:7:2
6:7:3
6:7:4
6:7:5
6:7:6
6:7:7
6:7:8
6:7:9
6:7:10
6:8:1
6:8:2
6:8:3
6:8:4
6:8:5
6:8:6
6:8:7
6:8:8
6:8:9
6:8:10
6:9:1
6:9:2
6:9:3
6:9:4
6:9:5
6:9:6
6:9:7
6:9:8
6:9:9
6:9:10
6:10:1
6:10:2
6:10:3
6:10:4
6:10:5
6:10:6
6:10:7
6:10:8
6:10:9
6:10:10
7:1:1
7:1:2
7:1:3
7:1:4
7:1:5
7:1:6
7:1:7
7:1:8
7:1:9
7:1:10
7:2:1
7:2:2
7:2:3
7:2:4
7:2:5
7:2:6
7:2:7
7:2:8
7:2:9
7:2:10
7:3:1
7:3:2
7:3:3
7:3:4
7:3:5
7:3:6
7:3:7
7:3:8
7:3:9
7:3:10
7:4:1
7:4:2
7:4:3
7:4:4
7:4:5
7:4:6
7:4:7
7:4:8
7:4:9
7:4:10
7:5:1
7:5:2
7:5:3
7:5:4
7:5:5
7:5:6
7:5:7
7:5:8
7:5:9
7:5:10
7:6:1
7:6:2
7:6:3
7:6:4
7:6:5
7:6:6
7:6:7
7:6:8
7:6:9
7:6:10
7:7:1
7:7:2
7:7:3
7:7:4
7:7:5
7:7:6
7:7:7
7:7:8
7:7:9
7:7:10
7:8:1
7:8:2
7:8:3
7:8:4
7:8:5
7:8:6
7:8:7
7:8:8
7:8:9
7:8:10
7:9:1
7:9:2
7:9:3
7:9:4
7:9:5
7:9:6
7:9:7
7:9:8
7:9:9
7:9:10
7:10:1
7:10:2
7:10:3
7:10:4
7:10:5
7:10:6
7:10:7
7:10:8
7:10:9
7:10:10
8:1:1
8:1:2
8:1:3
8:1:4
8:1:5
8:1:6
8:1:7
8:1:8
8:1:9
8:1:10
8:2:1
8:2:2
8:2:3
8:2:4
8:2:5
8:2:6
8:2:7
8:2:8
8:2:9
8:2:10
8:3:1
8:3:2
8:3:3
8:3:4
8:3:5
8:3:6
8:3:7
8:3:8
8:3:9
8:3:10
8:4:1
8:4:2
8:4:3
8:4:4
8:4:5
8:4:6
8:4:7
8:4:8
8:4:9
8:4:10
8:5:1
8:5:2
8:5:3
8:5:4
8:5:5
8:5:6
8:5:7
8:5:8
8:5:9
8:5:10
8:6:1
8:6:2
8:6:3
8:6:4
8:6:5
8:6:6
8:6:7
8:6:8
8:6:9
8:6:10
8:7:1
8:7:2
8:7:3
8:7:4
8:7:5
8:7:6
8:7:7
8:7:8
8:7:9
8:7:10
8:8:1
8:8:2
8:8:3
8:8:4
8:8:5
8:8:6
8:8:7
8:8:8
8:8:9
8:8:10
8:9:1
8:9:2
8:9:3
8:9:4
8:9:5
8:9:6
8:9:7
8:9:8
8:9:9
8:9:10
8:10:1
8:10:2
8:10:3
8:10:4
8:10:5
8:10:6
8:10:7
8:10:8
8:10:9
8:10:10
9:1:1
9:1:2
9:1:3
9:1:4
9:1:5
9:1:6
9:1:7
9:1:8
9:1:9
9:1:10
9:2:1
9:2:2
9:2:3
9:2:4
9:2:5
9:2:6
9:2:7
9:2:8
9:2:9
9:2:10
9:3:1
9:3:2
9:3:3
9:3:4
9:3:5
9:3:6
9:3:7
9:3:8
9:3:9
9:3:10
9:4:1
9:4:2
9:4:3
9:4:4
9:4:5
9:4:6
9:4:7
9:4:8
9:4:9
9:4:10
9:5:1
9:5:2
9:5:3
9:5:4
9:5:5
9:5:6
9:5:7
9:5:8
9:5:9
9:5:10
9:6:1
9:6:2
9:6:3
9:6:4
9:6:5
9:6:6
9:6:7
9:6:8
9:6:9
9:6:10
9:7:1
9:7:2
9:7:3
9:7:4
9:7:5
9:7:6
9:7:7
9:7:8
9:7:9
9:7:10
9:8:1
9:8:2
9:8:3
9:8:4
9:8:5
9:8:6
9:8:7
9:8:8
9:8:9
9:8:10
9:9:1
9:9:2
9:9:3
9:9:4
9:9:5
9:9:6
9:9:7
9:9:8
9:9:9
9:9:10
9:10:1
9:10:2
9:10:3
9:10:4
9:10:5
9:10:6
9:10:7
9:10:8
9:10:9
9:10:10
10:1:1
10:1:2
10:1:3
10:1:4
10:1:5
10:1:6
10:1:7
10:1:8
10:1:9
10:1:10
10:2:1
10:2:2
10:2:3
10:2:4
10:2:5
10:2:6
10:2:7
10:2:8
10:2:9
10:2:10
10:3:1
10:3:2
10:3:3
10:3:4
10:3:5
10:3:6
10:3:7
10:3:8
10:3:9
10:3:10
10:4:1
10:4:2
10:4:3
10:4:4
10:4:5
10:4:6
10:4:7
10:4:8
10:4:9
10:4:10
10:5:1
10:5:2
10:5:3
10:5:4
10:5:5
10:5:6
10:5:7
10:5:8
10:5:9
10:5:10
10:6:1
10:6:2
10:6:3
10:6:4
10:6:5
10:6:6
10:6:7
10:6:8
10:6:9
10:6:10
10:7:1
10:7:2
10:7:3
10:7:4
10:7:5
10:7:6
10:7:7
10:7:8
10:7:9
10:7:10
10:8:1
10:8:2
10:8:3
10:8:4
10:8:5
10:8:6
10:8:7
10:8:8
10:8:9
10:8:10
10:9:1
10:9:2
10:9:3
10:9:4
10:9:5
10:9:6
10:9:7
10:9:8
10:9:9
10:9:10
10:10:1
10:10:2
10:10:3
10:10:4
10:10:5
10:10:6
10:10:7
10:10:8
10:10:9
10:10:10

Any more questions? lol :)
This post was last modified: 01-03-2014, 12:47 AM by AceInfinity.


Microsoft MVP .NET Programming - (2012 - Present)
®Crestron DMC-T Certified Automation Programmer

Development Site: aceinfinity.net

 ▲
 ▲ ▲

01-07-2014, 03:34 PM #6
Lee Stevens
Senior Member
***
Posts: 345 Threads:54 Joined: Feb 2012 Reputation: 12

RE: DateTine Parse
Hi Ace,

Maybe i've got the wrong idea but i mean i need to search where BETWEEN
"Monday 30 December 2013 - 00:00:00" AND "Monday 30 December 2013 - 23:59:59"

So it has to include the day month year.

01-07-2014, 07:38 PM #7
AceInfinity
Developer
*******
Administrators
Posts: 9,733 Threads:1,026 Joined: Jun 2011 Reputation: 76

RE: DateTine Parse
I don't see why that's an issue either... All those values have numerical representations that follow in increasing order for a point in time which comes after a previous. The solution to something like that is as trivial as figuring out how you would check between say 0 and 10. Unsure

For a smaller example, yet in which the logic still stays the same, think about how you would calculate between 3:30pm and 5:45pm.

Hours: 3 and 5 (compare these)

If they are equal, then check the next significant value, the minutes: 30 and 45.

If this were 5:45 and 5:30, then you know the hour is insignificant if it's already 5, otherwise, compare for being between 30 and 45.

The easy part is that once you have a DateTime object, it really doesn't matter what the previous format was. You can use the > and < operators to compare. (ie. You don't even need LINQ...)

Code:
DateTime d1 = DateTime.Now;
DateTime d2 = DateTime.Now.AddHours(3.5);
DateTime checkTime = DateTime.Now.AddHours(2);

bool isBetween = checkTime > d1 && checkTime < d2;
Console.WriteLine(isBetween ? "Between" : "Outside of the range");

cheers
This post was last modified: 01-07-2014, 07:44 PM by AceInfinity.


Microsoft MVP .NET Programming - (2012 - Present)
®Crestron DMC-T Certified Automation Programmer

Development Site: aceinfinity.net

 ▲
 ▲ ▲

01-08-2014, 10:15 PM #8
Lee Stevens
Senior Member
***
Posts: 345 Threads:54 Joined: Feb 2012 Reputation: 12

RE: DateTime Parse
Thanks Ace,

I couldn't get it working before you posted your solution so i just changed it back to a normal format and separated the date and time into two fields.

And now it's working. :)




Forum Jump:


Possibly Related Threads...
Thread Author Replies Views Last Post
  [help]httpwebrequest/HtmlAgilityPack html parse? ѕα3єкα 18 10,301 02-25-2017, 05:23 PM
Last Post: AceInfinity
  Parse By Class simx 4 2,774 06-20-2013, 09:57 PM
Last Post: AceInfinity
   [Help] How to parse json response techwizz 11 9,309 02-29-2012, 12:18 PM
Last Post: Twisted-X
   Parse Help ReDDeMiSe 19 7,073 01-01-2012, 05:03 PM
Last Post: AceInfinity


Users browsing this thread: 1 Guest(s)