如何计算SSRS公式字段中两个日期的天数(How to calculate number of days by two dates in SSRS formula field)

如何计算SSRS公式字段中两个日期的天数(How to calculate number of days by two dates in SSRS formula field)

我有一个SSRS报告，我在那里有一个表格，其中有一个名为“日期数”的列，它位于两个日期之间。 我通过数据源获取这些日期（日期时间），但不知道如何计算no。 这两个日期在一个tablix单元格公式中的天数b / w。

任何帮助将不胜感激。

提前致谢。

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.

最满意答案

以下将得到两个日期之间的差异。

=则DateDiff（ “d”， “01君-2011”， “10君-2011”）

在表格单元格中，它会是...

= DateDiff（“d”，YourDataSet.Fields！FirstDate.Value，YourDataSet.Fields！SecondDate.Value）

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)