|
|
|
|
SQL Reporting Services - Answers to your questions
| |
|
Author |
Thread:
DateDiff Error |
|
Kathyc
|
DateDiff Error
Posted:
Sunday, March 15, 2009 1:16 PM (GST)
|
|
In my SRS report, I need to calculate the num of days between the date the record
was created on and the date the record was closed. I used this function in the
expression area of my textbox:
=DateDiff ("d", Fields!actualclosedate, Fields!createdon)
I get this error:
[rsRuntimeErrorInExpression] The Value expression for the textbox ‘textbox6’ contains an
error: Argument 'Date1' cannot be converted to type 'Date'.
I verfied that the 2 fields were in fact date fields.
What have I done wrong?
|
|
|
|
|
|
|
|
|