DateTime gets converted in Salesforce from Postman

apexdatetimelightning-datatablepostman

I'm receiving a datetime string as a response in postman from a service. but when I'm converting the string value to date time. The value is getting converted to date time as expected but it is displaying the user time zone queried or used in table. Is it not possible to convert the date time value from string to dateTime and store in date Time field with the same value?

Best Answer

Date.valueOf is the wrong method, as it is meant to parse times in the user's time zone. You can use Date.valueOfGmt instead. Alternatively, consider JSON.deserialize:

DateTime transDateTime = (DateTime)JSON.deserialize(transDateString, DateTime.class);

This will allow you to parse the date time in GMT without any string manipulation.

Related Solutions

[SalesForce] How to convert date string to DateTime type without GMT

Looks like DateTime.parse() takes the string and parses it based on the context users locale to produce a GMT date/time in the database. DateTime.format(String) should create an output string in based on the timezone of the current context user.

So you should be able to use when data comes in:

DateTime dt = DateTime.parse('11/6/2014 12:00 AM');

Then when you go to call the web service you'd use something like:

String dtOut = dt.format('d/M/y'); -- Or M/d/y if you're using American dates.

And for the bonus, you could just use a different argument in the format function such as:

String timOut = dt.format('h:m a');

[SalesForce] Convert date in JSON to Date from String

You can always convert the value again after you have parsed your JSON. Try using the Date.parse(...) method on the string.

A.Start_Date__C = Date.parse(caa.Start_date);

Best Answer

Related Solutions

[SalesForce] How to convert date string to DateTime type without GMT

[SalesForce] Convert date in JSON to Date from String

Related Topic