Best answer

Converting Transform:Compare Dates Output to Minutes

  • 15 May 2023
  • 4 replies
  • 26 views

Userlevel 1

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

 

icon

Best answer by Troy Tessalone 15 May 2023, 17:48

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 7
Badge +14

Hi @dshaines 

Can you please clarify your question?

Your screenshot shows 4 variables mapped.

Which would produce this value: 074041

 

Userlevel 1

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.

 

Userlevel 7
Badge +14

@dshaines 

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

Userlevel 1

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