The only way to display a date that is not in your data that I know of is to use a Dates table. If you can add a table to your database, I usually use something like the following that will cover any type of date you might need for reporting:
DATE_TYPE Varchar
START_DATE Date
END_DATE Date
DATE_TYPE is the following: DAY, WEEK, MONTH, QUARTER, YEAR
Left join FROM this table TO the date field in your data and then group on the date from this table.
I use this table for several types of things: filling in dates that aren't in the data, grouping/aggregating data at different date levels, etc.
-Dell
IP Logged
