dbTalk Databases Forums  

How to create this calculated member?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss How to create this calculated member? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
SAM
 
Posts: n/a

Default How to create this calculated member? - 08-22-2006 , 03:16 PM






I want to create a calculated member to count the number of days past due.

SELECT DATEDIFF(day, o.datecreated, getdate()) AS no_of_days_pastdue

How can I do this in AS 2K?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.