Does anyone no why when I use the DateDiff function in a calculaetd member
that it returns a off the wall decimal number? Instead of the actual
difference in days?

I'm storing dates as DateTime in format of 1/1/2003

-mike

Hi Michael,

Firstly, I would like you to check to see your expression with DateDiff
function is able to work fine using Query Analyzer. You can get the actual
difference in days.

Then, I think we do not need to use calculated measure to meet your
requirements. We can try to define a measure to show the actual difference
in days. In the property of this measure, we try to type the following
statements in the "source column" box on the Basic tab:

DateDiff(d,"dbo"."Orders"."OrderDate", "dbo"."Orders"."ShippedDate")

"dbo"."Orders"."OrderDate is the column name in the Orders table in the
Northwind database.
"dbo"."Orders"."ShippedDate" is the column name in the Orders table in the
Northwind database.

Set the Data Type to be Integer and the Display Format to be standard on
the advanced tab in the measure property. Then process the cube and I can
get the expected data on my side.

Please feel free to post in the group if this solves your problem or if you
would like further assistance.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Hi,
Usually to get the DateDiff in Calculated member,we have
to cast both dates into Integer then do the substraction.
It will give exact results in Days.
I think it will work.
Pls try this way.
Regards,
Vanchi

Hi Michael Shao,
Your method will work when both the dates are taken from
the same row of the record.
If I need to take from different rows,
For example
PONO Product OD DD
1 1 10/11/2003 13/11/2003
1 2 11/11/2003 15/11/2003
Here i want to find the DateDiff for Product
and DateDiff for PONO.
How to get the DateDiff using same measure.
In this case,You have to create Measure1 for OD as Cast(OD
as int) with Agg function as Min
create Measure2 for DD as Cast(DD as int) with Agg
Function as Max
Then create Calculated Measure as Measure2-Measure1
This is the way you can get the DateDiff for differnt
dimentions using the same Measure.

Am I right.

Pls comment.

Vanchi.

)