|
Home > Archive > MS SQL Server OLAP > December 2005 > using DateDiff in Analysis 2005 BIDS
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
using DateDiff in Analysis 2005 BIDS
|
|
| Karthik Rao 2005-12-28, 3:24 am |
| 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
| |
| Karthik Rao 2005-12-28, 1:24 pm |
| 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
|
|
|
|
|