Calculate seconds in timer activity

[priyanka1028]

Hi Team,

How to calculate seconds based on start date and end date in format (yyyy-mm-dd) in timer activity of workflow?

Please help me by providing your answer.

[shloke04 · Accepted solution]

Hi @priyanka1028 ,

Select "Script" as an value within the attribute "Timer based on" within your Timer activity within a workflow as shown below:

Now make use of below script to get the seconds between your date attributes:

// Set 'answer' to the number of seconds this timer should wait
var start = new GlideDateTime("Pass your value here.");
var end = new GlideDateTime("Pass your value here.");

// Duration in seconds

answer = gs.dateDiff(start, end, true); // returns the number of seconds as String

[shloke04 · Accepted solution]

Hi @priyanka1028 ,

Select "Script" as an value within the attribute "Timer based on" within your Timer activity within a workflow as shown below:

Now make use of below script to get the seconds between your date attributes:

// Set 'answer' to the number of seconds this timer should wait
var start = new GlideDateTime("Pass your value here.");
var end = new GlideDateTime("Pass your value here.");

// Duration in seconds

answer = gs.dateDiff(start, end, true); // returns the number of seconds as String

[shloke04 · Accepted solution]

@priyanka1028  - In case if you want to pass a value from an attribute instead of hardcoding the date value in script above, then you would need to follow below steps:

1. Do a glide Record on your table and retrieve the value of date attributes.

2. Pass that into line 1 and 2 in script shared above.

3. Rest component remains same.

[priyanka1028]

Thank you so much @shloke04 

This one is going to help me a lot