Counting days

[Anonymous]

How can I count the number of days between two dates?

I have ClaimDate and ConcludedDate and I want to count the number of days in between.

[prashanth1712]

Hi,

U can use like (ConcludeDate - ClaimDate)

thanks

[arulsettu]

try this

NetWorkDays(ClaimDate ,ConcludedDate )

[Anonymous]

I tried to put this in a KPI, but it did not work. Does anyone have another idea?

[reshmakala]

If you want to calculate all days in between dates, then you can use

ConcludedDate - ClaimDate

If you want to calculate only working days (Monday-Friday), then use

Networkdays (ClaimDate , ConcludedDate )

[hubertdudek]

Floor(ConcludedDate) - Floor(ClaimDate)

[Anonymous]

Hi

Try it.

=Floor(Interval(ConcludedDate-ClaimDate,'DD'))

Regards.