Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: dbo ufnGetAccountingStartDate (function)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 18:07


wikibot

function dbo.ufnGetAccountingStartDate
DescriptionScalar 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 TypeObject TypeReferencing ObjectChild TypeChild Object
ExecuteTableSales.SalesOrderHeaderTriggeruSalesOrderHeader

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.