[SalesForce] How to provide default DateTime value in UTC time

I am providing a default value to a DateTime field in my apex class.

customobject.DateTime__c = DateTime.parse('01/01/1990 12:00 AM');

I want to set the default value to 01/01/1990 12:00 am UTC time. Am i setting it properly.

My Salesforce organization timezone is set to Pacific. So when I go back and check the field in Salesforce, it is displayed as 01/01/1990 12:00 AM. I am trying to figure out, if it saved the datetime field to 01/01/1990 12:00 AM Pacific time or UTC?

Best Answer

DateTime.parse() uses the current user's locale and time zone. You can tell because when you view it in the UI, it has the same value you set. It's converted internally to UTC, but the value will not be 01/01/1990 12:00 am UTC because it's adjusted from your local Pacific time.

Instead, use DateTime.newInstanceGmt(year, month, date, hour, minute, second):

DateTime dt = DateTime.newInstanceGmt(1990, 1, 1, 0, 0, 0);

Related Solutions

[SalesForce] DateTime formula field to compare to a specific time

Tinkered around with this for a bit and here's one workable method. Have a field updated to today's date, have a second time based workflow activate 14 hours after today's date field. That will reliably kick off a process at 2pm according to your org time, whole hours only allowed unfortunately.

For your second request though for a comparison of date time for current date. DateTimeValue takes a literal string, so you can pass it the required date, add the specific time required for the comparison: IF(NOW() < DateTimeValue("2016-11-09 09:30:00"),'true','false')

edit: just a reminder that if you're trying to trigger something from a formula, formula changes do not kick off workflow recalculations.

[SalesForce] Remove timezone conversion from the value of ui:inputDateTime

The Lightning Framework has a localization service that you can use in your JS to format date/time values which should be helpful to you with your issue.

// get currrent date/time and localize based on user's browser settings

var dateFormat = $A.get("$Locale.dateFormat");
var dateString = $A.localizationService.formatDateTime(new Date(), dateFormat);


// explicitly format date/time value

var dateFormat = "MMMM d, yyyy h:mm a";
var userLocaleLang = $A.get("$Locale.LangLocale");
return $A.localizationService.formatDateTime(date, dateFormat,userLocaleLang);

Best Answer

Related Solutions

[SalesForce] DateTime formula field to compare to a specific time

[SalesForce] Remove timezone conversion from the value of ui:inputDateTime

Related Topic