Adds a specified number of seconds to a date.
dateaddseconds(date, seconds)
| Parameter | Type | Description |
|---|---|---|
date |
String | Starting date (ISO 8601 format) |
seconds |
Number | Number of seconds to add (can be negative) |
String - The resulting date in ISO 8601 format.
The dateaddseconds function adds a specified number of seconds to a date and returns the new date/time. Use negative numbers to subtract seconds.
Result = DATEADDSECONDS("2025-04-01T10:30:00.000Z", 30)
// Result: "2025-04-01T10:30:30.000Z"
Result = DATEADDSECONDS("2025-04-01T10:30:30.000Z", -15)
// Result: "2025-04-01T10:30:15.000Z"
TimeoutExpiry = DATEADDSECONDS(RequestTime, TimeoutSeconds)
- Timeouts: Calculate expiry times
- Animations: Timing calculations
- Performance: Measure durations
- Precision timing: Second-level calculations
- dateaddmilliseconds - Add milliseconds
- dateaddminutes - Add minutes
- dateseconddifference - Calculate second difference
- Returns ISO 8601 formatted string
- Handles minute/hour boundaries
- Negative values subtract seconds
- Uses the Dates service internally