I am writing a front end application that interfaces to a cube with a date
dimension that has year, quarter, month, day (corresponding to email message
dates) The specs call for a drop down list box that would allow the user
to select messages received within "1 week", "1 month", "6 Months", "1
Year", "all Time"

I've got the all time query covered (haha), but i can't figure out how I'm
going to code the others without hardcoding dates in the query????????

I need help from the MDX gods.....

TIA,
Scott