Issue with “Days Revoked After Termination” Calculation in Workflow

Celeya

I am working on an Alteryx workflow to replicate SQL logic for calculating Days Revoked After Termination. The logic should compute:

ALTER FUNCTION [dbo].[CalculateWorkingDays](@StartDate DATE, @EndDate DATE)

RETURNS INT

AS

BEGIN

DECLARE @TotalDays INT = DATEDIFF(day, @StartDate, @EndDate);

DECLARE @WeekendDays INT = 0;

DECLARE @CurrentDate DATE = @StartDate;

WHILE @CurrentDate < @EndDate

BEGIN

IF DATEPART(weekday, @CurrentDate) IN (1, 7)

BEGIN

SET @WeekendDays = @WeekendDays + 1;

END

SET @CurrentDate = DATEADD(day, 1, @CurrentDate);

END

RETURN @TotalDays - @WeekendDays;

END;

(Start Date = Termination Date

End Date = Effective Date)

Expected behavior:

• If Termination Date = 2025-05-09 and Effective Date = 2025-05-10 →
  TotalDays = 1, WeekendDays = 0, Result = 1
  
  the workflow i have created has been attached here. Appreciate if anyone could help on this

Dummy wf.yxzp

binu_acs

@Celeya can you try the attached workflow

Tota_days_11042025.yxmd