Converting Transform:Compare Dates Output to Minutes
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.
Page 1 / 1
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!