Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Date Difference in a parameter

Author  Topic 

1sabine8
Posting Yak Master

130 Posts

Posted - 2010-07-29 : 03:29:58
Hi,

I have two parameters (From Date, To Date) of type text (20100131).

I need to add a hidden parameter that will give me the difference in days between the two dates after converting them from text to date?

What formula should i use and how can i make the parameter be filled at run time?

Thanks in advance
   

- Advertisement -