Calculating the Length of Stay 1

[mchambers]

Hello,

I need to add a length of stay column to a report and I am having difficulty formating the output. I was wondering if anyone can help me with this.

I have:
=Fields!dischargedate.Value - Fields!admitdate.Value

Then in properties under format I have tried all the different numbering formats
ex: g, F0, etc....

This is the output I continue to get: Ex:101.00:00:00

Thanks

 

[RiverGuy]

Try this

=datediff("d", Fields!admitdate.Value, Fields!dischargedate.Value)

 

[mchambers]

Your awesome that worked great! Thanks! Have a wonderful weekend!