Ask Search:
Chris HunterChris Hunter 

Looking to create a field that will return the difference between a Date/Time field on an object and the current Date and time NOW(). Id like this field to just return an integer.

Best Answer chosen by Chris Hunter
Ahilesh RagavanAhilesh Ragavan
Hello Chris,

Create a Formula(Number) field like this:
NOW()- DateTimeField__c
Note: Make sure to choose "0" for the number of decimal places.
 

All Answers

Ahilesh RagavanAhilesh Ragavan
Hello Chris,

Create a Formula(Number) field like this:
NOW()- DateTimeField__c
Note: Make sure to choose "0" for the number of decimal places.
 
This was selected as the best answer
Sutha ParathSutha Parath
Create a Formulat(Number) field with this formula:
Now()  -  Date_Time_Field__c