Ask a Question
Ask Question Login
Corporate Training
  1. Community
  2. Devops
  3. Question
Devops

DateDiff In SSRS Problem

Asked by Ranjana Agrahari Jul 15, 2021 2.0K views 1 answer
Share

About this question

 I am trying to do a report in SSRS and trying to calculate the number of days between the patient's re-admission and the original admission date.

Here's my formula

=FORMAT (DateDiff("DAY", Fields!ReAdmitDate.Value, Fields!AdmitDate.Value) >= 30)

 

tried =(DateDiff("DAY", Fields!ReAdmitDate.Value, Fields!AdmitDate.Value) >= 30)

 

but I am not able to resolve it, the field comes with "#Error

 

Data type from the DB is "DATE" , format is 06/17/2010 12:00:00 AM

 

Any idea what I'm missing in my code?? 


Your answer

1 Answer

More Devops discussions

Learn & Explore

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

Latest DevOps Blogs

Guides, tips and career advice on DevOps from JanBask experts.