Difference between revisions of "Dbo.ufnGetAccountingEndDatefunction"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Function | dbo.ufnGetAccountingEndDate |- valign="top" | '''Description |...)
 
(No difference)

Latest revision as of 00:07, 24 June 2010

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