2 date dimensions -
11-22-2004
, 09:03 PM
I have a table with 2 date fields.
I would like to be able to sort/filter on each of these fields
independently. Basically, one is for project start date, and one is for
project completion date. I can't do age, or anything easy.. Since a lot of
the projects have wierd completion dates (this data comes from an as400 and
it looks like they dont have very good validation in their programs).
In the 2nd date field, there are a lot of values that aren't within
acceptable values--
Should i just make a named set that has like the ranges that I want; and
then give people the ability to query a group at a time?
I can't figure out what I need to do in order to do this-- previously I have
made a view with a seperate copy of this data, and then joined to that.. it
just seems so inefficient. |