You need to sign in to do that
Don't have an account?
GOAL_KEEPER How to calculate seconds from 2 dates?
Hi how do i get the seconds like 0-60 (so counting and resetting) from something like Now()-CreatedDate?
Starting November 20, the site will be set to read-only.
On December 4, 2023,
Apex Code Development (90768)
General Development (55146)
Visualforce Development (37251)
Lightning (18265)
APIs and Integration (17146)
Trailhead (11680)
Formulas & Validation Rules Discussion (11337)
Other Salesforce Applications (8116)
Jobs Board (6655)
Force.com Sites & Site.com (4842)
Mobile (2694)
You need to sign in to do that
Don't have an account?
GOAL_KEEPER Hi how do i get the seconds like 0-60 (so counting and resetting) from something like Now()-CreatedDate?
Since NOW() - CreatedDate returns a value in days, you can multiply by the number of hours in a day, minutes in an hour, and seconds in a minute to get the total number of seconds:
It sounds like you're looking for a value between 0-60, so just the number of seconds that are not accounted for by minutes? In that case you can use MOD() along with the previous value to determine how many seconds are left over after dividing by 60 seconds: