Properties

Owner:	dbo
Type:	SQL scalar function
Encrypted:
Creation Date:	04/26/2006
Modification Date:	04/26/2006
Description:	Scalar function used in the uSalesOrderHeader trigger to set the ending account date.

Creation options

QUOTED_IDENTIFIER:
ANSI_NULLS:

Parameters

	Name	Direction	DataType	Length	Default	Description
	@RETURN_VALUE	RETURN	datetime	8

Total: 1 parameter(s)

SQL

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

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

GO
SET QUOTED_IDENTIFIER OFF
GO

GO
SET ANSI_NULLS OFF
GO

See Also

List of functions