Dbo.ufnGetAccountingEndDate (function)

From dbscript Online Help
Jump to: navigation, search

wikibot

Function dbo.ufnGetAccountingEndDate
Description Scalar function used in the uSalesOrderHeader trigger to set the starting account date.

Source

CREATE FUNCTION [dbo].[ufnGetAccountingEndDate]()
RETURNS [datetime] 
AS 
BEGIN
    RETURN DATEADD(millisecond, -2, CONVERT(datetime, '20040701', 112));
END;

Dependencies

Reference Type Object Type Referencing Object Child Type Child Object
Execute Table Sales.SalesOrderHeader Trigger uSalesOrderHeader


automatically generated

function dbo.ufnGetAccountingEndDate
Description Scalar function used in the uSalesOrderHeader trigger to set the starting account date.

CREATE FUNCTION [dbo].[ufnGetAccountingEndDate]()
RETURNS [datetime] 
AS 
BEGIN
    RETURN DATEADD(millisecond, -2, CONVERT(datetime, '20040701', 112));
END;


Reference Type Object Type Referencing Object Child Type Child Object
Execute Table Sales.SalesOrderHeader Trigger uSalesOrderHeader