Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sorting on a member property that is a date

Status
Not open for further replies.
cltalbott3

cltalbott3

IS-IT--Management
Mar 15, 2002
2
US
When we use the following in our MDX query our sorting does not work as intended. The dates are not sorted correctly, in fact it seems to random.

Set [OrderSet] as 'Order( {[NonEmptyRowsSet] },[ClientJob].currentmember.properties("Open Date") ,BASC )'

The open date member property is a smalldatetime format within our SQL database. We have set it's data type to DBTimeStamp.

Any suggestions would be appreciated.
 
Status
Not open for further replies.

Similar threads

isoman4not5
  • Locked
  • Question
Is it possible to derive a recurring date based upon a single date?
Replies
0
Views
624
isoman4not5
isoman4not5
Vary88
  • Locked
  • Question
Both One-Many and Many-One relations in fact table
Replies
0
Views
663
Vary88
Vary88
maxzikpi
  • Locked
  • Question
How to Create a cube with a survey result. Pls help!
Replies
4
Views
803
maxzikpi
maxzikpi
LAM123
  • Locked
  • Question
Help, script on ODBC is not working
Replies
1
Views
200
SkipVought
S
brk1221
  • Locked
  • Question
Failed to open a rowset - Crystal Reports
Replies
2
Views
727
brk1221
brk1221

Part and Inventory Search

Sponsor

Back
Top