Function - udf_StringToDate

Properties

Property	Value
Name	udf_StringToDate
Schema	dbo
Function Type	Scalar
Deterministic	False
Is Encrypted	False
Ansi Nulls Status	True
Quoted Identifier Status	True
Description

Parameters

Name	Data Type	Direction	Description
@DateText	varchar(8)	Input

Parent Dependencies (objects that udf_StringToDate depends on)

Name	Type
arch_AR_Receivables	View
usp_DimApplication_Select	StoredProcedure
usp_DimCurriculum_Select	StoredProcedure
usp_DimStudent_Select	StoredProcedure
usp_FactActiveEnrollmentSnapshot_FullSelect	StoredProcedure
usp_FactActiveEnrollmentSnapshot_FullSelect_EOT_ToBeDeleted	StoredProcedure
usp_FactApplicationStatus_Select	StoredProcedure
usp_FactArchivedEnrollmentSnapshot_FullSelect	StoredProcedure
usp_FactArchivedEnrollmentSnapshot_FullSelect_EOT_ToBeDeleted	StoredProcedure

Child Dependencies (objects that depend on udf_StringToDate)

Name

Type

Extended Properties

Object

Property

Value

DDL

/****** Object: UserDefinedFunction [dbo].[udf_StringToDate] Script Date: 03/09/2017 16:47:10 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE FUNCTION [dbo].[udf_StringToDate]
    (
    @DateText VARCHAR(8)
    )
RETURNS datetime
AS
BEGIN
    DECLARE @TargetDateString VARCHAR(10)
    DECLARE @ConvertedDate datetime
    SET @TargetDateString = LEFT(@DateText,4) + '-' +
        SUBSTRING(@DateText,5,2) + '-' +
        RIGHT(@DateText,2)
    SET @ConvertedDate = cast(@TargetDateString AS DATETIME)
    RETURN @ConvertedDate
END