Search code examples
expressionreport-viewer2010

Subtracting between two dates for total days

i have three columns for Date In, Date Out, Total Days. If in Date In: 8/1/2011 and Date Out: 8/12/2011 Then the Total Days would be: 11 days. If Date Out is empty then Total Days = Current Date - Date In.

Problem: i cout get the total days if Date out is empty and using current date just fine, but getting total between date out and date in is giving me an error.

In the textbox in the reportviewer i have this expression:

=IIf(Fields!DateOut.Value=" "," ",Fields!TotalDays.Value)

The TotalDays is Current Date - Date In which i calculate in a stored procedure and just return the results.

I was thing of doing this but still i am getting an #Error in the textbox if i tried subtracting between date out and in if they are not empty. 

=IIf(Fields!DateOut.Value=" ",DateDiff("d",Fields!DateOut.Value,Fields!DateIn.Value),Fields!TotalDays.Value)

Any suggestions.... Thanks

Solution

  • I know this is a little late, but i came up with the same issue. Here's what I did:

    =CDate(Fields!DateOut.Value).Subtract(Fields!DateIn.Value).Days

    Hope this helps!