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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculating the difference between 2 dates

Status
Not open for further replies.
mattbrenn

mattbrenn

Programmer
Jun 4, 2003
11
GB
Hi there
I wondering how to calculate the difference between 2 dates. The cube i inherited contains within it a Promised Date and a Received Date, I've been tasked with showing the difference between the 2 and I'm not sure how best to go about it.
TIA
Matt
 
Sort by date Sort by votes
Hi,

Can you use DATEDIFF()?

=DATEDIFF(dd, [dim].[date1], [dim].[Date2])

Not sure but might be worth a go.

Hope this helps.

Leigh Moore
Business Systems Manager
Vets4Pets Veterinary Group
 
Upvote 0 Downvote
Cheers for the info Leigh.

I used this in the stored procedure I've got to create the fact table, the data comes out fine as is now useable in the OLAP cube.
Thanks again.

Matt
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

edvmat
  • Locked
  • Question
Error in the conversion sql query
Replies
2
Views
233
edvmat
edvmat
JP_Quinn
  • Locked
  • Question
Adding New Column to Dimension Table, Used in Other Cubes, Must I Update the Models of Other Cubes?
Replies
0
Views
196
JP_Quinn
JP_Quinn
RRinTetons
  • Locked
  • Question
Move cube to a new location on the same server
Replies
1
Views
216
blom0344
blom0344
capitanosol
  • Locked
  • Question
Extracting the DataSource Property from DataTable in DSV
Replies
2
Views
130
capitanosol
capitanosol
Rolaper
  • Locked
  • Question
MDX Calc measure to accomdate Smi-Additive and delta SCD at the same time?
Replies
0
Views
100
Rolaper
Rolaper

Part and Inventory Search

Sponsor

Back
Top