[SalesForce] System.TypeException: Invalid date/time: 2019-01-03T00:26:01.711-02:00

Im trying to format this String into DateTime.

String

2019-01-03T00:26:01.711-02:00

Code

 String data = '2019-01-03T00:26:01.711-02:00';
 Datetime dt = DateTime.parse(data);

Exception

System.TypeException: Invalid date/time: 2019-01-03T00:26:01.711-02:00

Best Answer

To parse DateTimes in this ISO format, you need to use JSON deserialization.

String data = '2019-01-03T00:26:01.711-02:00';
Datetime dt = (DateTime)JSON.deserialize('"' + data + '"', DateTime.class);

The JSON parser understands ISO format, while DateTime.parse() uses the running user's locale settings.

Related Solutions

[SalesForce] i am getting System.TypeException: Invalid date: 30/06/2016

parse() returns the formatted string depends on the user locale. Check your locale in user record and its date format here Supported locales

From your message noticed its not accepting format(dd/mm/yyyy) 30/06/2016, so you may need to change the format of bufferdate string as per your locale like (mm/dd/yyyy or dd-mm-yyyy..) or need to change the locale in user record.

[SalesForce] Convert String into formated date

Why not do it yourself using String split?

    String myDate ='10/12/1990';
List<String> arrayDate = myDate.split('/');
String newDateFormat = arrayDate[2]+'-'+arrayDate[1]+'-'+arrayDate[0];

System.debug(newDateFormat);

Best Answer

Related Solutions

[SalesForce] i am getting System.TypeException: Invalid date: 30/06/2016

[SalesForce] Convert String into formated date

Related Topic