When a record is created and trigger executes (after insert)- updating a field, I want to calculate the time difference between the last modified date and the created date in seconds. If it's greater than 10 seconds, update the field as true else false. Can someone tell how to calculate in seconds?
Log in to share your answer and help other learners.
Log in to answerBest Answer · By JanBask Salesforce Expert
Answered on Apr 26, 2023
The answer to your question - How can createddate be larger than lastmodifieddate is -
createdDate-LastModifiedDate
Returns the difference in the number of days - it's like yesterday- today - 1
If you multiply by 24 (24 hours a day ) returns the value in hours
then by 60 (60 minutes) returns the value in minutes
then again another 60 (60 seconds) returns the value in seconds
Difference in seconds
(createdDate-lastModifiedDate)*24*60*60Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.
Step-by-step Salesforce guides from industry experts
Common Salesforce interview questions, answered
Guides, tips and career advice on Salesforce from JanBask experts.
Salesforce Cost for Salesforce Certification: Exam Fees by Type, Retakes & Hidden Costs
Salesforce certification exam fees run $75 to $4,500, and most cost $200. See cost by role, retakes, taxes, discounts, and…
Salesforce Salesforce Admin Certification Cost 2026: Exam Fees, Retake & Other Expenses
Learn the Salesforce Admin certification cost in 2026, including the exam fee, retake cost, taxes, discounts, preparation…
Salesforce How to Get Into Salesforce With No Experience
Wondering if you can get a Salesforce job with no experience? Learn how to pick a career path, build real skills, and land your…
Salesforce How to Become a Salesforce Developer Without Experience
No coding background? Learn how to become a Salesforce Developer step by step - skills to build, projects to create, and how to…