Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. Business Analyst
  3. Question
Business Analyst

How the ssrs expressions works for DateDiff?

Asked by Abhinav Pillai May 28, 2021 1.6K views 1 answer
Share

About this question

I am currently working on SSRS 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.

Your answer

1 Answer

More Business Analyst discussions

Learn & Explore

Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.

Latest Business Analyst Blogs

Guides, tips and career advice on Business Analyst from JanBask experts.