• DOCUMENTATION
  • WORKATO BLOG
  • PRODUCT BLOG
  • Return to Workato
  • Log in
  • ☰
  • Solutions Articles
  • Forums/Discussions
  • Submitted Tickets
New Topic
Discussions Recipe Building Formula Mode Questions
S

Saul Macht

started a topic over 3 years ago

Calculate time interval between 2 dates

I want to set up a condition such that when a record is updated within 10min of a another date, perform certain actions. How can I do this?


Amanda Wong

said over 3 years ago

You can use conditional action, and make use of formula mode to find the difference between 2 date time stamps. You will have to ensure that the 2 date data pills have the same format. Since you are looking at a time difference of 10 minutes, you should be comparing datetime stamps.


You will also need to fill the time difference in seconds, so for 10 minutes, it would be 600 seconds.


Trigger Example Screenshot:


image



Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2020   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato