Approval Reminders On Weekends

I am wanting to bypass weekends for 1st and 2nd Reminders for approvals. I have the 1st reminder working, but I'm not sure how to set up the 2nd reminder.

I've added a process variable in the Start Node for OriginalTimeOutDays. The 1st reminder is set to <!NewTimeOutDays> and I have this in the assign node:

NewTimeOutDays = NewTimeOut(OriginalTimeOutDays);

How can I do this same thing for a 2nd reminder?

Find more posts tagged with

Comments

Robert Canham

You should do the 2nd reminder the same way. The time for the 2nd timeout counts from when the user action starts, not when the first reminder goes out.

JD Miller

We run 2 variables and use a switch statement. I'm sure there's a more efficient way of writing it, but it works and is easy to read. Before each User Action we run an Assign node with the following:

var d = new Date();

switch (d.getDay())

{

case 0: RemDays1 = 4; RemDays2 = 9; TimeOutDays = 11; break;

case 1: RemDays1 = 4; RemDays2 = 9; TimeOutDays = 11; break;

case 2: RemDays1 = 6; RemDays2 = 9; TimeOutDays = 13; break;

case 3: RemDays1 = 6; RemDays2 = 9; TimeOutDays = 13; break;

case 4: RemDays1 = 6; RemDays2 = 11; TimeOutDays = 13; break;

case 5: RemDays1 = 6; RemDays2 = 11; TimeOutDays = 13; break;

case 6: RemDays1 = 5; RemDays2 = 10; TimeOutDays = 12; break;

}

nathan-taylor

How can you add another day to the calculation? We are wanting the 2nd reminder to go out 1 day after the 1st reminder. If the 1st reminder goes out on Friday, we would want the 2nd reminder to go out on Monday.

Robert Canham

Your NewTimeOut function should handle that for you. If your first reminder is 1 day and your second is at 2 days (remember it is based off the start of the user action not when the first reminder goes) you would do two function calls:

FirstReminder = NewTimeOut(1);

SecondReminder = NewTimeOut(2);

XA Virtual Summit - Foundation for the future.mp4

Legacy Contributor

Just for something different... We are on SQL server here, and I find doing date math in sql easier. You just put a couple of date functions into a select statement in an SQL Query node and assign the output to a variable. You can output the date in pretty much whatever format you want. Here is an example of code for an sql node that does nothing but get some different dates:

DECLARE @MY_DATE DATETIME

SET @MY_DATE = GETDATE()

SELECT CONVERT(CHAR(08),@MY_DATE,112) AS TODAY_DATE,

DATENAME(DW,@MY_DATE) AS DAY_OF_WEEK,

CONVERT(CHAR(08),DATEADD(DD,1,EOMONTH(@MY_DATE, -1)),112) AS FIRSTOFMONTH,

CONVERT(CHAR(08),EOMONTH(@MY_DATE),112) AS LASTOFMONTH

Here is a link to the msoft T-SQL date functions reference: docs.microsoft.com/.../date-and-time-data-types-and-functions-transact-sql

Here is a link to the cast and convert functions, which allow you to format the date: docs.microsoft.com/.../cast-and-convert-transact-sql

nathan-taylor

That worked. Thanks!

Copyright © 2025 Infor. All rights reserved.