title: SSRS Format calculated timespan in dd:hh:mm:ss
body: <p>I have a report and one of the fields calculates a timespan in an expression e.g</p>
  
  <pre><code>=Fields!Date1.Value-Fields!Date2.Value
  </code></pre>
  
  <p>I would like to display in the format dd:hh:mm:ss so days,hours,minutes and seconds. If i just leave the expression it sort of works but i get milliseconds which i don't want and if there are no days then that value disappears.</p>
  
  <p>I've seen lots of examples using formatting to get HH:mm:ss but not on how to do the days.</p>