Assign value of a string (containing date and time) to two different variable (one for Date and one for Time)

Question

I have a string ("CompletionDate") which contains the value "2/28/2017 5:24:00 PM" Now I have 2 variables (EDate and ETime). I want to assign the Date to EDate (i.e 2/28/2017) and Time to ETime (i.e. 5:24:00 PM). How can I split the Date and Time from a single string. Kindly Help. My approach right now is like :

string CompletionDate = string.Empty;
string ProjectEDate = string.Empty;
string ProjectETime = string.Empty;
CompletionDate = "2017-03-29 12:58:00";
DateTime dt = DateTime.ParseExact(CompletionDate, "yyyy-MM-dd", CultureInfo.CreateSpecificCulture("en-us"));
DateTime dt1 = DateTime.ParseExact(CompletionDate, "HH:mm:ss", CultureInfo.CreateSpecificCulture("en-us"));
var ProjectEDate = dt.ToString();
var ProjectETime = dt1.ToString();

But its throwing exception that string is not in correct format. Kindly help

Have edited my question – Mahatma Aladdin Jan 31 '17 at 13:02 — Mahatma Aladdin, Jan 31 '17 at 13:02

score 4 · Answer 1 · answered Jan 31 '17 at 13:09

@Chris pointed one of your problems, but you have one more. You are passing full date time string and trying to treat it as date or time only, which is not true. Instead I suggest you to parse DateTime object with both date and time, and then take whatever you need from parsed object:

CultureInfo enUS = CultureInfo.CreateSpecificCulture("en-us");
DateTime dt = DateTime.ParseExact(CompletionDate, "yyyy-MM-dd HH:mm:ss", enUS);
var ProjectEDate = dt.Date.ToString();
var ProjectETime = dt.TimeOfDay.ToString();

score 3 · Answer 2 · edited May 23 '17 at 12:01

3

DateTime.ParseExact(CompletionDate, "yyy-MM-dd", ...

You are missing 4th 'y' in date format string:

"yyyy-MM-dd"
    ^
   here

and: String was not recognized as a valid DateTime " format dd/MM/yyyy"

edited May 23 '17 at 12:01

Community

1
1

answered Jan 31 '17 at 13:01

Chris Vermeijlen

67
9

thank you Sergey. My English and formatting skills are not really good :-).But learning ;-). – Chris Vermeijlen Jan 31 '17 at 13:04

score 3 · Accepted Answer · answered Jan 31 '17 at 13:14

You need to specify the full format as same as the input string to parse method.

DateTime dt = DateTime.ParseExact(CompletionDate, "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.CreateSpecificCulture("en-us"));

To get results you can use below methods available by default in DateTime.

dt.ToShortTimeString()
"12:58 PM"
dt.ToLongTimeString()
"12:58:00 PM"
dt.ToLongDateString()
"Wednesday, March 29, 2017"
dt.ToShortDateString()
"3/29/2017"

Or you can specify the format to ToString method.

dt.ToString("yyyy-MM-dd")
"2017-03-29"
dt.ToString("HH:mm:ss")
"12:58:00"

score 2 · Answer 4 · answered Jan 31 '17 at 13:08

Why do you parse into DateTime and then convert to a string using ToString again? Couldn´t you just simply use String.Split when all you want is to split the time from the day and you know the exact format?

var CompletionDate = "2017-03-29 12:58:00";
var tmp = CompletionDate.Split(' ');

var ProjectEDate = tmp[0];
var ProjectETime = tmp[1];

Assign value of a string (containing date and time) to two different variable (one for Date and one for Time)

4 Answers4