I have a custom field (custom_field__c) on lead object and in my trigger i want to check difference between NOW() and current value of custom_field__c. And if difference is more than 5 seconds then do some action.
So for this requirement will below formula work 100% ? or are there any limitations or problems in it. Thanks for help:)
( NOW() - custom_field__c )*24*60*60
Also how to check if dateTime field is empty: Will custom_field__c == Null works?