I'm trying to run the following, but keep getting error message
'Incorrect Syntax near keyword DECLARE'

CREATE Function dbo.fnGetEndDate()
Returns EndDate /*This is a UDT*/
AS
DECLARE @GetEndDate as EndDate
BEGIN
Set @GetEndDate=CAST(frmLauncher.Evaluation_ID AS varchar(20))
RETURN @GetEndDate
END

Try this and tell if it works:

CREATE Function dbo.fnGetEndDate()
Returns EndDate /*This is a UDT*/
AS
BEGIN
DECLARE @GetEndDate EndDate
Set @GetEndDate=(Select CAST(frmLauncher.Evaluation_ID AS varchar(20)) from TableName)
RETURN @GetEndDate
END

Yes Guarav,
That worked beautifully, thank you. I'm still in my VBA mindset.

THANKS!!

You are most welcome.

Cheers!!!!