Calculation of Day

[gregorytan]

Hi

If i need to total the no of day, in calculation which Function should I use?

eg. 14/04/09 to 16/04/09. Total no of day is 3 day

Thank

gregory

[mr_vodka]

date2 - date1

[gregorytan]

Hi

It should be 3 day. If we use date2 - date1 I only get 2 day

Thank

gregory

[comment]

Use EndDate - StartDate + 1, if you want to include both in the count.

[gregorytan]

Hi

Thanks. Got it.

Cheers

gregory

[mr_vodka]

Well most want the difference in the dates. You can try the following:

Case ( NOT IsEmpty ( date1 ) AND NOT IsEmpty ( date2 ); date2 - date1 + 1 )

[gregorytan]

Hi

Yes both work for me.

Thanks

cheers

gregory