How to calculate number of days

[Anonymous]

How to calculate number of days in a selection ?

In the following example , the number of days is 54?

[Gysbert_Wassenaar]

I hope you have a date field: Count(distinct MyDate)

[agustinbobba]

Hi Jaweher89,

Here an example of what you need, if you doesn't have a Date field  you can make it on the script, or use the field separately.

Best Regard!,

Agustin

[alexdataiq]

Wouldn't that be 56 days?

31 (Jan) + 29 (Feb ) = 60 days - 4 excluded = 56 days?

[swuehl]

Eduardo, days 1 and two are excluded from both january and february, hence in total 6 excluded days.

[alexdataiq]

Oh yes, you're absolutely right! My bad.

Thanks!