http://dbshelp.devio.at/index.php?action=history&feed=atom&title=Dbo.ufnGetAccountingEndDatefunction 2026-05-31T00:41:51Z Revision history for this page on the wiki MediaWiki 1.30.0 http://dbshelp.devio.at/index.php?title=Dbo.ufnGetAccountingEndDatefunction&diff=2546&oldid=prev 2010-06-23T22:07:34Z

<p>New page: == wikibot == {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot; |- valign=&quot;top&quot; | &#039;&#039;&#039;Function | dbo.ufnGetAccountingEndDate |- valign=&quot;top&quot; | &#039;&#039;&#039;Description |...</p> <p><b>New page</b></p><div>== wikibot ==<br /> <br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- valign=&quot;top&quot;<br /> | '''Function<br /> | dbo.ufnGetAccountingEndDate<br /> |- valign=&quot;top&quot;<br /> | '''Description<br /> | Scalar function used in the uSalesOrderHeader trigger to set the starting account date.<br /> |}<br /> <br /> === Source ===<br /> &lt;pre&gt;<br /> CREATE FUNCTION [dbo].[ufnGetAccountingEndDate]()<br /> RETURNS [datetime] <br /> AS <br /> BEGIN<br /> RETURN DATEADD(millisecond, -2, CONVERT(datetime, '20040701', 112));<br /> END;<br /> &lt;/pre&gt;<br /> <br /> === Dependencies ===<br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Reference Type<br /> | '''Object Type<br /> | '''Referencing Object<br /> <br /> | '''Child Type<br /> | '''Child Object<br /> <br /> |- valign=&quot;top&quot;<br /> | Execute<br /> | Table<br /> | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]<br /> <br /> | Trigger<br /> | uSalesOrderHeader<br /> |}</div>

Bot