Search Results

a new formula field of type Number with two decimal places: ((DATETIMEVALUE("2010-01-01 " + Time2__c) - DATETIMEVALUE("2010-01-01 " + Time1__c))*1440) This formula uses these times and created two datetime …

If you want to assign your apex date variable to some javascript variable you can do it just by creating a new Date with your apex variable as parameter: <script> var d = new Date('{!date}'); …

You can use Date Formats and Date Literals together with Date Functions directly in the SOQL query: Select Id From Account Where CreatedDate = TODAY And HOUR_IN_DAY(CreatedDate) = 6

Here is a cool doc about date formats in SOQL: Date Formats and Date Literals You could use LAST_WEEK for sure. Something like: Select Id, Name From Opportunity Where CloseDate = LAST_WEEK

String myDate = o.CloseDate.year() + '-' + o.CloseDate.month() + '-' + o.CloseDate.day(); Or: String myDate = String.valueOf(o.CloseDate).SubString(0,10);

UPDATE For the following format February 2, 2013 please use: Datetime myDatetime = Datetime.now(); String myDatetimeStr = myDatetime.format('MMMM d, yyyy'); Im using the following functions … for the timestamp: // This method returns a whole timestamp as a string public String timeStamp(){ Datetime dt = Datetime.NOW(); String day = checkLength(String.valueOf(dt.day())); String …

Use daysBetween date startDate = date.newInstance(2008, 1, 1); date dueDate = date.newInstance(2008, 1, 30); integer numberDaysDue = startDate.daysBetween(dueDate); Here ist the doc: Date Methods

You need to use DATETIMEVALUE(...) function, like this: DATETIMEVALUE("2013-11-15 12:00:00") Or just NOW() function Read more about functions

hour: Returns the hour component of a Datetime in the local time zone of the context user minute: Returns the minute component of a Datetime in the local time zone of the context user (From here: … Datetime Methods) So why can't you just create a time you want from a goven Datetime? …

I think here you will be needed an apex method, something like this: public List<String> monthList = new List<String>{'January', 'February', …

Will you believe me or not, the problem here is, that the event was misspelled: onChange ---> wrong onchange ---> right This is the case for the Salesforce support team.

I have tested the following: NOW() field (DateTime formula) DateTime field Difference field with formula NOW()- ut__Datetime__c (number formula, 2 decimal places) Works well: …