How to calculate number of days by two dates in SSRS formula field

asp.net datetime date reporting-services ssrs-tablix
asma picture asma · Jun 27, 2011 · Viewed 35.2k times · Source

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.

Answer

Damien Dennehy picture Damien Dennehy · Jun 27, 2011

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)

Related questions

DateTime.TryParse issue with dates of yyyy-dd-MM format

I have the following date in string format "2011-29-01 12:00 am" . Now I am trying to convert that to datetime format with the following code: DateTime.TryParse(dateTime, out dt); But I am alwayws getting dt as {1/1/0001 12:00:00 AM} , Can you …

Read More
Subtract 1 year from datetime

I have seen a lot of info on how to subtract one datetime from the other and how to add years on to a datetime. but the following is giving me a headache.... When a user inserts a record a …

Read More
ASP.NET DateTime Picker

is there any good free/open source time picker control that goes well with ASP.NET Calendar control?

Read More