Built-in Date Function?

[BobLoblaws]

Is there a built-in date function that does the following?
Basically, I want something that can return all dates that are not in a table.

Example.
SELECT AllDates() FROM tbl_Work
WHERE AllDates() <> WorkDate AND
AllDates() BETWEEN '01-01-2002' AND '12-31-2002'

 

[forecasting]

I am curious to see if there is such a function. I basically do the same sort of thing with date and time. I wound up creating a table for holding the date information, then outer join to that table and select all records which have the nulls