Deserializing a string from JSON to DateTime in Apex yields "Invalid format" error

Question

I have a string as,

field name : start Date: 2016-11-14 08:00 AM ( string type)

how to convert this to Date time. I tried Date.parseDate and below option also.

String val = recruiters[j].Start_Time_Formula__c; 
                            system.debug('val ::'+ val);
                            DateTime date1 = (DateTime)Json.deserialize('"'+val+'"', DateTime.class);
                            system.debug('date1 ::' + date1);

but I am getting error as,

System.JSONException: Invalid format: "2016-11-14 08:00 AM" is malformed at " 08:00 AM": (System Code)

I referred the below link and got with the above error.

Convert String DateTime to User Locale Date Time

any help ?

Answer 1

You must use an ISO 8601 date, specifically something like:

2016-10-30T15:27:02.000Z

Which is October 30th, 2016, at 3:27 pm (+2 seconds) in Greenwich Mean Time.

To parse dates in the user's locale, use the appropriate form for the user. For example, in the United States, we would write:

10/30/2016 3:27 pm

Carefully note the order of month, day, and year, and pay attention to the separator (/). You need to input the date exactly as salesforce shows dates to you, because it is locale dependent.

Answer 2

If you have datetime in string as: 2017-10-26T12:48:47.000+0000, then you can use below approach. Usually, when we make query in code or dev console or workbench, we get datetime in this format. So, if you want to just copy that value and assign it to date value you can use Datetime.valueOf() by replacing T with space.

String strDate1  = '2017-07-25 00:00:00';
String strDate2 = '2017-07-21 00:00:00';

Datetime dt1 = Datetime.valueOf(strDate1);
Datetime dt2 = Datetime.valueOf(strDate2);

// This is just to show it works fine.
Integer noOfDays = dt2.Date().daysBetween(dt1.Date());
System.debug('No. Of Days : '+noOfDays);

Answer 3

I think you have an issue with the hyphens used instead of slashes, if you fix that, the DateTime.parse method will consume your string without issue. Note that the format will be dependent on the user (dd/mm/yyyy vs mm/dd/yyyy) I referenced this during testing Datetime format ignores am/pm? the below code compiles fine.

String testDateString = '11-11-2014 08:00 AM'.replace('-','/');
DateTime testDate = DateTime.parse(testDateString);
String convertedDate = testDate.formatGmt('yyyy-MM-dd\'T\'HH:mm:ss\'Z\'');
System.debug('xxx'+convertedDate);

After you have the datetime in the second line, you can do the comparison you require.