The Sql Server GETDATE() function not allowed in the body of user-defined functions, as it is non-deterministic. The GetNow view provides a means to generate a system date/time that can be used in Sql Server user-defined functions.
DROP VIEW dbo.GetNow
CREATE VIEW dbo.GetNow AS
SELECT GetDate() Now
GRANT SELECT ON dbo.GetNow TO PUBLIC