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
over 1 year ago
This is possible. You will need to use formula mode to do this.
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?
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
Allan Teng from Workato
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
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 from Workato
You can do that too. Either way works.