You need to sign in to do that
Don't have an account?
Lumber Dev
Formula Not Working to Provide True/False Statement
Hi All,
VERY new to salesforce and being an admin in general. I am trying to create a field on a custom object to provide "True" if the time the object was last modified is earlier than or equal to the current Date/Time. I created a custom field to provide the date and time last modified already and that is working as it should. I am using:
IF ( NOW() - Date_Time_Last_Modified__c <= 7200000 ,"TRUE", "FALSE" )
But it is returning True always even if the statement is not. I am not sure if something is wrong with my formula?
VERY new to salesforce and being an admin in general. I am trying to create a field on a custom object to provide "True" if the time the object was last modified is earlier than or equal to the current Date/Time. I created a custom field to provide the date and time last modified already and that is working as it should. I am using:
IF ( NOW() - Date_Time_Last_Modified__c <= 7200000 ,"TRUE", "FALSE" )
But it is returning True always even if the statement is not. I am not sure if something is wrong with my formula?
The difference of date/datetime in formulas is expressed in number of days ( 24h ).
( NOW() - Date_Time_Last_Modified__c ) days * 24 hours * 60 minutes => total of minutes
7200000 ms = 2 hours = 120 minutes
( NOW() - Date_Time_Last_Modified__c ) * 24 * 60 <= 120 ( formula with calculations but easy to understand )