跳过周末工作日任务NetSuite [英] Skip weekends Business day tasks NetSuite

问题描述

使用NetSuite，我试图使每月任务的创建自动化.这些任务将在该月的最后一天，该月的前一天以及该月的最后一天的1,2,3,4,5天之后进行.但是，任务不能只在周末完成，而只能在工作日完成.因此，如果一天是坐在沙发上或在太阳下，则日期必须调高.如何使用我的自定义记录来计算跳过周末的下个月任务日期?这是记录的屏幕截图-看到10/4和10/5分别在周六和周日落下，我该如何跳过周六和周日?我使用sql函数选项来生成星期几和日期.

Using NetSuite, I am trying to automate the creation of monthly tasks. These tasks will fall on the last day of the month, a day before, and 1,2,3,4,5 days after the last day of the month. But, the tasks can't be due on a weekend, only business days. So if the day falls on a sat or sun the dates have to move up. How can I use my custom record to calculate the next months task dates skipping weekends? Here is a screenshot of the record - see that 10/4 and 10/5 fall on saturday and sunday, how can I have it skip sat and sunday? I used the sql function option to generate the dates and days of the week.

推荐答案

我测试了以下公式.用您的字段名称替换custbody_date.该公式应在下个月"列中设置.

I tested the following formula. Replace custbody_date with your field name. This formula should be set in your 'next month' column.

CASE WHEN INSTR(to_char({custbody_date}, 'DAY'),'SATURDAY') != 0 
THEN {custbody_date}+2 
WHEN INSTR(to_char({custbody_date}, 'DAY'),'SUNDAY') != 0 
THEN {custbody_date}+1 ELSE {custbody_date} 
END

这还应该使您能够设置下个月"(跳过周六和周日)的值.

This should also give you an idea to set the value for 'Next Month Day' (skipping saturday and sunday).

这篇关于跳过周末工作日任务NetSuite的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！