9

I have an SSRS report and I have a table there, in which I have a column named as No. Of Days which are lying between two dates. I am getting those dates (datetime) through datasource but don't know how to calculate number of days between these two dates in a tablix cell formula.

halfer
  • 19,824
  • 17
  • 99
  • 186
asma
  • 2,795
  • 13
  • 60
  • 87

1 Answers1

22

The following will get the difference between two dates:

=DateDiff("d","01-Jun-2011","10-Jun-2011")

which results in 9.

In a table cell it will be something like:

=DateDiff("d",YourDataSet.Fields!FirstDate.Value, YourDataSet.Fields!SecondDate.Value)
halfer
  • 19,824
  • 17
  • 99
  • 186
Damien Dennehy
  • 3,937
  • 2
  • 19
  • 21