Hi,

How can I obtain the days between two dates, one given in the fact table,
and the other one selected as the final date of the time dimension selected?

If i choose September 2005, i want the days between the date in the fact
table and Sep 30, 2005.

Thanks,
Octavio

You will have to link a dimension to this date field. AS aggregates fact
records and dates do not aggregate.

Then you should be able to use the technique Chris Webb outlines on his
blog at http://spaces.msn.com/members/cwebbbi/Blog/cns!1pi7ETChsJ1un_
2s41jm9Iyg!113.entry

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1455E006-92EA-48CD-B474-B9245126ECB0 (AT) microsoft (DOT) com>,
OctavioVargas (AT) discussions (DOT) microsoft.com says...