Service Manager

This is the latest version of the help for Ivanti Service Manager 2018. If you cannot find some of the features described in the help, you may be using an older version of the application. To upgrade the application, click here.
To view the help for the latest version of Service Manager, click here

SecondsToTime

Converts a number of seconds to the equivalent duration in the form dd:hh:mm:ss.

Syntax

SecondsToTime(value)

Enabled For

For a description of the business object categories, see Notes on "Enabled For".

Business Object Category	Yes/No
Business Rules: Before-Save Rules	Yes
Business Rules: Calculation Rules (After Save, with or without Also Recalculate on Load)	Yes
Business Rules: Calculation Rules (Before Save or Always, without Also Recalculate On Load)	Yes
Business Rules: Calculation Rules (Before Save or Always, with Recalculate On Load)	Yes
Business Rules: Editing Rules	Yes1
Business Rules: Initialization Rules	Yes
Business Rules: Read Only Rules	No
Business Rules: Required Rules	Yes1
Business Rules: Validation Rules	Yes1
Client Expressions	No
Object Permissions	No
Services	Yes
LDAP	Yes
Mobile	Yes
Quick Actions (except UI Quick Actions)	Yes
UI Quick Actions	No
Reports	Yes
Search/Dashboard without field references	Yes
Search/Dashboard with field references	No
1. Except when this field appears on a form or is triggered by such a field.

Parameters

value

The number of seconds to be converted.

Return Value

Text value of the form dd:hh:mm:ss. For example, 06:06:55:58.

•For durations less than one day, the dd: is omitted.

•For durations less than one hour, the hh: is also omitted.

•For durations less than one minute, the mm: is also omitted.

Example

To find the difference between the created date and time and the last modified date and time, use the following example:

$(SecondsToTime(DateDiff("second", ToString(LastModDateTime), ToString(CreatedDateTime))))

In this example, the DateDiff() function is used to compute the difference in seconds between the value of the LastModDateTime and CreatedDateTime times. The function then converts the seconds to a text value in the dd:hh:mm:ss format.