HI:
i need to weight inventory by days to calculate cost of carry. I tried
to use a VBA function
Datediff(day, date1, date2). This is in a claculated meber in BIDS.

Where date1 is the second inflow of a particular product, and date2 is
the first inflow.

I tried all values for interval like d,dd, day, even the enum values 3
and 4. But I keep getting error argument interval expected etc. If I do
not quote strings, I get a dimension not found error.

What am I doing wrong?
Thanks a lot

I used DateDiff("D", Date1, Date2) and it seems to work. I even tried
using the EnumValues, but got the Interval error.

Is this function case sensitive? Are there any local issues here? Why
isnt the enum Value working?

Thanks