Date time Formats

Mayank

9y1kVisual Basic .NET

I need to compare

string date="May 16, 2010 7:20:12 AM CDT" with

Current date time

I am getting the below exception when I convert date to datetime.

"Invalid date time format"

13 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta9y ago
Hey

DateTime.ParseExtract(..) needs the extact format as you mentioned otherwise it throws exception.

Use this one
string dts = "Thursday, May 11, 2017 1:09:08 AM CDT";

            var dt = DateTime.Parse(dts.Replace("CDT","")).Add(new TimeSpan(05, 00, 00));
            var GMT =dt.ToString("dddd, MMM dd, yyyy H:mm:ss tt zzz");
CDT stands for Central Daylight Time. GMT is known as Greenwich Mean Time. GMT is 5 hours ahead of CDT. So, when it is it will be
You can get the difference in the below link
https://www.worldtimebuddy.com/cdt-to-gmt-converter
Mayank9y ago
I am getting the exception in below code:

string dts = "Thursday, May 11, 2017 1:09:08 PM CDT";
DateTime dt =
DateTime.ParseExact(dts.Replace("CDT", "-05:00"), "MMM dd, yyyy H:mm:ss tt zzz", null);

Please correct my code.
Khaja Moizuddin9y ago
You were supposed to use date in date time data type instead of string.
Amit Gupta9y ago
Hey
Central Daylight Time (CDT) is 5 hours behind Coordinated Universal Time (UTC). This time zone is a Daylight Saving Time time zone and is used in: North America.
This time zone is often called Central Daylight Time.

Thats why we have deducted -5 hrs from UTC.

Read the below reference for further detailed information
https://www.timeanddate.com/time/zones/cdt
Mayank9y ago
Amit,

When I run the code date converts from May 16, 2010 7:20:12 AM CDT to
5/16/2010 5:50:12 PM .If we compare it with datetime.now then it is correct or not because time changes from 7:20:12 AM to 5:50:12 PM?
Amit Gupta9y ago
@Mayank

Please read the below link

https://en.m.wikipedia.org/wiki/Central_Time_Zone#Central_Daylight_Time
Mayank9y ago
Hi Amit,

Can you explain me your answer, What is the requirement of below code?
dts.Replace("CDT", "-05:00")

I have gone through the link mentioned by you but I was not able to understand the logic behind code.
Rafnas T P9y ago
string date="May 16, 2010 7:20:12 AM CDT"
DateTime dtfromAPI=Convert.ToDateTime(date.Replace(" CDT",""));

then compare dtfromAPI with DateTime.Now() like below
if(dtfromAPI >DateTime.Now())
{
//...
}
Amit Gupta9y ago
CDT - Central DateTime
string dts = "May 16, 2010 7:20:12 AM CDT";
DateTime dt =
    DateTime.ParseExact(dts.Replace("CDT", "-05:00"), "MMM dd, yyyy H:mm:ss tt zzz", null);
Ref
http://stackoverflow.com/questions/11873179/format-string-to-datetime-with-timezone
Mayank9y ago
Hi Sir,

My question is how can we compare with current date time?
Rafnas T P9y ago
timezone is not allowed in datetime
Mayank9y ago
Hi,

Below date is returning from API and it is a valid date.
I need to compare with current date time.
Rafnas T P9y ago
what is CDT? remove CDT

string date="May 16, 2010 7:20:12 AM CDT"
this is not a correct format thats why you are getting error
it should be

string date="May 16, 2010 7:20:12 AM"