Hi Megan:
I believe using the "date table" is your best option.
Regards,
Michael Larkins Certified Teradata Master Certified Teradata SQL Instructor
Attachments
Library
Quick Reference
Archives
Sample Index
2008 Indexes