Invalid Data type

[robert030975]

HI guys

Been a while but I can't see the wood for the trees and need a little help.


I have created a dimension PreIntoWH

=If (CurrentDate() > [Po UNDelivered].[Current Into WH Date]; RelativeDate(CurrentDate();7);[Po UNDelivered].[Current P Into WH Date]) which works fine

however when I try to do a daysBetween

=DaysBetween([Release Date];Max([PreIntoWH))


It keeps comming up


WIS 10037
Message:
The expression/sub-expression at position {n} uses an invalid data type. Specify a valid data type.

Cause:
An expression contains an invalid data type. (For example, you have attempted to pass a string to a function that requires a date.)

Action:
Use a valid data type in the expression.

Like what I have already set both to short date?

I know this can be done on SQL but I really would like to do this on the report.

Many Thanks

Robert

 

[lbass]

I think you might be posting in the wrong forum. What reporting software are you using?

-LB

 

[hilfy]

I assume that by "dimension" you mean a dimension in a universe. If that is the case, what is the data type of PreIntoWH (top right of the dimension's properties in Designer)?

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.