This user-defined function creates a table of date ranges. Continue reading
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.
Convert a string value into its equivalent Date Range.