Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
3358 Zobrazení

I am currently working on SRSS reports there is one column i.e Holding period where we actually calculate for

Since the purchase date, how many days the company is on hold in our database

and ssrs expression is

=DateDiff(DateInterval.Day, Fields!BuyDate.Value, First(Fields!Date.Value, "DailyPosition"))
 

I think i am performing a wrong calculation, Could any one help to execute correct calculation.

Basically, purchase date is a normal date column from table , and "DailyPosition" is my dataset name from ssrs report.

Lets discuss an example: Company ABC buy date is 2012-03-13 00:00:00.000 and last parameter date is 2012-12-31 00:00:00.000

Mentioned query results as 293 select DATEDIFF (day,'2012-03-13 00:00:00.000','2012-12-31 00:00:00.000')

Above result is wrong as my holding period is 126 days only

please help me to correct the expression.
 

Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
1
bře 15
6739
2
bře 15
7173
0
lis 22
3002
5
říj 22
14284
0
zář 22
4517