UFN_DISBURSEMENTPROCESSTEMPLATE_GETDATESTRING

Returns a formatted string that describes how many around the process the date should be

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@NUMBEROFDAYS	int	IN
@BEFOREAFTERCODE	tinyint	IN

Definition

Copy



create function dbo.UFN_DISBURSEMENTPROCESSTEMPLATE_GETDATESTRING
(
  @NUMBEROFDAYS as int,
  @BEFOREAFTERCODE as tinyint
)
returns nvarchar(100)
with execute as caller
as begin
    declare @DATE nvarchar(100);
  IF @BEFOREAFTERCODE is null
  BEGIN
    SET @DATE = 'Process date' + CASE WHEN @NUMBEROFDAYS > 0 THEN 
                ' plus ' + CAST(@NUMBEROFDAYS as nvarchar) + 
                CASE WHEN @NUMBEROFDAYS = 1 THEN ' day' ELSE ' days' 
                END ELSE '' END
  END
  ELSE
    SET @DATE = 'Process date' + CASE WHEN @NUMBEROFDAYS > 0 THEN 
                CASE WHEN @BEFOREAFTERCODE = 0 THEN ' plus ' ELSE ' minus ' END +
                CAST(@NUMBEROFDAYS as nvarchar) + CASE WHEN @NUMBEROFDAYS = 1 THEN 
                ' day' ELSE ' days' END ELSE '' END
  return @DATE
end