It's all about the answers!

Ask a question

How to calculate days from two dates in report

pugazhenthi samidurai (26423942) | asked Mar 08 '12, 8:26 a.m.

I want to calculate no.of.days from two dates in RTC BIRT report.

Thanks ,

Pugazh S

One answer

permanent link
pugazhenthi samidurai (26423942) | answered Mar 08 '12, 8:35 a.m.
I have found the solution for this

function days_between(date1, date2) {

// The number of milliseconds in one day
var ONE_DAY = 1000 * 60 * 60 * 24

// Convert both dates to milliseconds
var date1_ms = date1.getTime()
var date2_ms = date2.getTime()

// Calculate the difference in milliseconds
var difference_ms = Math.abs(date1_ms - date2_ms)

// Convert back to days and return
return Math.round(difference_ms/ONE_DAY)


Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.