• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Log in
  • ☰
  • Solutions
  • Forums
  • Tickets
New Topic
Discussions Q & A Formula Mode
S

Scott Talarico

started a topic about 2 years ago
Answered

Date Formula (Weekday vs weekend)

Is there a formula that will take a certain date and schedule an event that is the next business day?  As an example, if a recipe to schedule an event was triggered Saturday I would like it to schedule the event in Quickbase for Monday.  If it was triggered Monday I would like the event to be scheduled for Tuesday.  Basically skipping the weekends.  


Best Answer
A
Allan Teng from Workato said about 2 years ago

This is possible. You will need to use formula mode to do this.


<pill>.wday == 5 ? <pill>.+3.days : <pill>.wday == 6 ? <pill>.+2.days : <pill>.+1.days


More information about formula mode can be found here: https://support.workato.com/solution/articles/1000173152

Answer

Allan Teng from Workato

said about 2 years ago

This is possible. You will need to use formula mode to do this.


<pill>.wday == 5 ? <pill>.+3.days : <pill>.wday == 6 ? <pill>.+2.days : <pill>.+1.days


More information about formula mode can be found here: https://support.workato.com/solution/articles/1000173152

S

Scott Talarico

said about 2 years ago

I'm using a date field (mm/dd/yy) in QuickBase.  I can create a new field that will return day of the week.  Would that be the correct approach or should that conversion be added to the formula?

Allan Teng from Workato

said about 2 years ago

You can do that too. Either way works.

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
Expert Hour
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
Workato 2018 © | Privacy | Terms | +1 (844) GO-WORKATO
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato