USP_DATAFORMTEMPLATE_ADD_GLFISCALYEARPREVIOUS_PRELOAD

The load procedure used by the edit dataform template "Previous Fiscal Year Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@LASTENDDATE	datetime	INOUT	Last end date

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_GLFISCALYEARPREVIOUS_PRELOAD
(
    @LASTENDDATE datetime = null output
)
as
    set nocount on;

    declare @FirstStartDate datetime;
    select @FirstStartDate = MIN(STARTDATE) from dbo.GLFiscalPeriod

    if @FirstStartDate is not null
        set @LASTENDDATE = @FirstStartDate - 1

    return 0;