Hi,

I've seen a lot of posts with subject relating to VBA!Now(), but no one with
an example how to show data "not greater then today". I have a lot of future
data with no sense, so instead of limiting the Time dimension, I want to use
Calculated Member to not expose data related to the future days. In other
words, I don't want to see the future data. I believe the syntax depends on
the time dimension structure, so could someone show me an example of a
FoodMart cube.

Thanks.