Not the best, but seems to be working.

CREATE VIEW Test as Select DateAdd(hh,2,GetDate()) as TheDate

GO

CREATE FUNCTION TestDate()

Returns @TheTable TABLE ([GETDATE] DateTime) as

BEGIN

Insert @TheTable

Select TheDate From Test

RETURN

END

GO

CREATE FUNCTION TestDateII()

Returns DateTime

BEGIN

RETURN (Select [GetDate] from dbo.TestDate())

END

GO

Select dbo.TestDateII()

GO

Suspect the overhead will make it a bit slow, maybe OK for testing!