Dbo.ufnGetAccountingEndDate (function)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

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

Source[edit]

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

Dependencies[edit]

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


automatically generated[edit]

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