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
said
about 5 years ago
This is possible. You will need to use formula mode to do this.
For anyone else who has been hunting for this solution... this formula worked for me, but only after removing the dots in front of the plus signs in the accepted answer above:
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?
Answer
Allan Teng
said
about 5 years ago
This is possible. You will need to use formula mode to do this.
Scott Talarico
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.
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
Laura Boylan
For anyone else who has been hunting for this solution... this formula worked for me, but only after removing the dots in front of the plus signs in the accepted answer above:
In other words, this did not work for me:
<pill>.wday == 5 ? <pill>.+3.days : <pill>.wday == 6 ? <pill>.+2.days : <pill>.+1.days
Allan Teng
You can do that too. Either way works.
Scott Talarico
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
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