Skip to main content

Hello! Currently struggling with this one and I am unsure on how best to proceed. We are looking to convert the result of Compare Dates into a minutes format and webhook this into a field within DevOps. I am able to compare the dates and receive an output but cannot find a way to manipulate this date and achieve what’s needed. Thank you.

 

Compare Dates
Output

 

Hi @dshaines 

Can you please clarify your question?

Your screenshot shows 4 variables mapped.

Which would produce this value: 074041

 


Hi Troy. Sorry about the confusion. The question was “How do I take all outputs from CompareDates and convert it into minutes”. The current output of CompareDates gives me days, hours, minutes, and seconds. I was having an issue using this dynamic content and converting it into total minutes.

I was able to accomplish this by calling an Excel action.Using the SUM function, then patching the result via webhook into the necessary field in DevOps.

 


@dshaines 

FYI: You can use a Formatter > Numbers > Perform Math Operation action.


That makes it much easier! I missed that when trying to find a solution for this. Thank you!