dbo ufnGetAccountingStartDate (function)

RSS

Modified on 2011/08/27 11:16 by wikibot Categorized as Uncategorized

» dbo ufnGetAccountingStartDate (function)

wikibot ¶

Function	dbo.ufnGetAccountingStartDate
Description	Scalar function used in the uSalesOrderHeader trigger to set the ending account date.

CREATE FUNCTION [dbo].[ufnGetAccountingStartDate]()
RETURNS [datetime] 
AS 
BEGIN
    RETURN CONVERT(datetime, '20030701', 112);
END;

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