Hello,

In report Script, how to get no of days between two date.
Example, I wan to get no of days between tdpur200.rdat and current date:

No_of_days = Date() - tdpur200.rdat

Thank You.

Add tdpur200.rdat in the input fields of report
added field on the report with print field as
print field : (utc.num() - tdpur200.rdat) / 24 * 60 * 60
domain tcpono

Thank You All,
I found solution in this forum by using this coding.:


declaration:
long lng.cdat, lng.ddta, lng.ctim, lng.dtim, days.diff


detail.1:
before.layout:
utc.to.local(utc.num(), lng.cdat, lng.ctim)
utc.to.local(tdpur206.pdat, lng.ddta, lng.dtim)

days.diff = lng.cdat - lng.ddta